|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
SUMIF FUNCTION
Thank you!
"Max" wrote:
Try sumproduct for multi-criteria:
=SUMPRODUCT((SHEET1!C$1:C$953="Oats")*(SHEET1!F$1: F$953="Corn"),SHEET1!H$1:H$953)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads: 15,500, Files: 352, Subscribers: 53
xdemechanik
---
"Susan" wrote:
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!
|