SUMIF FUNCTION
Use SUMPRODUCT.
=SUMPRODUCT(--(Sheet1!C$1:C$953="oats"),--(Sheet1!F$1:F$953="Corn"),Sheet1!H$1:H$953)
HTH,
Paul
--
"Susan" wrote in message
...
Hello All,
Need to add a second criteria to this sumif.
=SUMIF(SHEET1!C$1:C$953,"OATS",SHEET1!H$1:H$953)
Now it is only adding dollars in col. H for any "oats" in col.C.
Would like sum of dollars if there are oats in col. C and corn in col. F.
Is this possible?
Thank you everyone!
|