Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#4
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! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to nest a left function within a sumif function? | Excel Worksheet Functions | |||
Using the TODAY() function in a SUMIF function | Excel Worksheet Functions | |||
SUMIF Function Inside SUMPRODUCT Function | Excel Worksheet Functions | |||
Can SUMIF function include AND function | Excel Worksheet Functions | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions |