SUMIF FUNCTION
 

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!

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!

SUMIF FUNCTION
 

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!

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!

SUMIF FUNCTION
 

Thank you!

"PCLIVE" wrote:

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!

SUMIF FUNCTION
 

Welcome, Susan
--
Max
Singapore
http://savefile.com/projects/236895
Downloads: 15,500, Files: 352, Subscribers: 53
xdemechanik
---
"Susan" wrote in message
...
Thank you!