SUMIf Formula

[DCT01]

I would like to write a formula that sums cells in column A if there is data in both column B and column C - please help.

 

[Aladin Akyurek]

=SUMPRODUCT($A$2:$A$100,--($B$2:$B$100<>""),--($C$2:$C$100<>""))

 

[PATSYS]

Assuming your data is from A1:C10

=Sum(if(B1:B10<>"",if(C1:C10<>"",A1:A10)))

confirm with CTRL+SHIFT+ENTER


*REVISED*

 

[DCT01]

Thank you - Aladin's formula worked. Patsys I could not get your to work.

 

[PATSYS]

It is an array formula that should give you results exactly just like that of Aladin's. Remember not just to press ENTER, you should press CTRL+SHIFT+ENTER.