Use 2 SUMIF() or use SUMPRODUCT():
Code:=SUMIF(B1:B20,"Apple",A1:A20)+SUMIF(B1:B20,"Orange",A1:A20) or =SUMPRODUCT(((B1:B20="Apple")+(B1:B20="Orange"))*(A1:A20))
|
Results 1 to 2 of 2
Thread: How to write a Countif then Sum?
Hybrid View
|
Click Here to Expand Forum to Full Width |
Reply With Quote