ExcelBanter - sumif2

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - sumif2 (https://www.excelbanter.com/excel-worksheet-functions/156013-sumif2.html)

ekkeindoha

sumif2

I've got it like this
A B C
30 2 JNB
11 3 CPT
10 4 RIO
11 5 JNB
13 6 JNB
10 7 CPT
And what I need are the total out of B only if A=11 and C=CPT.
I've had a previous one that worked the figures from B but it seems that I
must have this condition in as well.

Thanks

Duke Carey

sumif2

=sumproduct(--(A1:A10=11),--(c1:c10= "CPT"),B1:B10)

"ekkeindoha" wrote:

I've got it like this
A B C
30 2 JNB
11 3 CPT
10 4 RIO
11 5 JNB
13 6 JNB
10 7 CPT
And what I need are the total out of B only if A=11 and C=CPT.
I've had a previous one that worked the figures from B but it seems that I
must have this condition in as well.

Thanks

All times are GMT +1. The time now is 03:45 AM.