Using SUMIF/IF statements for multiple conditions
This was really helpful. Many thanks
" wrote:
You can do like this :
supose in range A11:C16 you have :
Currency Acount Value
3 1 7
3 2 15
1 1 14
2 2 23
3 1 21
The formula to get the sum of values with currency=3 and Acount=1 will
be
=SUM(IF((A12:A16=3)*(B12:B16=2);C12:C16;""))
This is a array formula so when entering the formula you must do Ctrl
Shift Enter
Regards
|