Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Numbers. Sum cells with conditions

Hello

I have three columns full of numbers; A, B and C.

I need a cell to have a formula that gives me the result of sum the cells of column C when in their corresponding ones in the same row, the value of the cell of A is greater than the value of that of B. That is, if in A5 we have the value 5 and in B5 the value 4, the value of C5 must be sum to that of other values ​​of cells in C where the fact that in the same row the value of A is greater than that of B. I would also need to know the times that happens, that the value of A is greater than that of B in the same row.

Thanks

iPad Pro Wi-Fi, iOS 11, null

Posted on Nov 15, 2017 2:22 PM

Reply
Question marked as Best reply

Posted on Nov 15, 2017 6:31 PM

Hi Francisco,


Try this. This table has a Header Row and two Footer Rows. Add another column (D)

User uploaded file

Formula in D2 (and Fill Down)

=IF(A2>B2,"Yes","No")


Formula in Footer cell D7 =SUMIF(D,"=Yes",C)

Formula in Footer cell D8 =COUNTIF(D,"=Yes")


Regards,

Ian.

10 replies

There are no replies.

Numbers. Sum cells with conditions

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.