Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIFS with 3 criteria instead of just 2
I am trying to get SUMIFS function to SUM a range of cells only if three
criteria are met. I have tried the SUMIFS function for two of the criteria and then added SUMIF to the end for the 3rd criteria, but it always defaults to the SUMIF function even though the first 2 criteria are not met. Example: =SUMIFS(C32:C33,E32:E33,"4",G32:G33,"6")+SUMIF(I32 :I33,"<96",C32:C33) It is adding cells together even when 4 & 6 criteria are not met. Anyone have any ideas! Thank you! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIFS with 3 criteria instead of just 2
=SUMPRODUCT(--(E32:E33=4),--(G32:G33=6),--(I32:I33<96,C32:C33)
-- Regards, Peo Sjoblom "Hopper" wrote in message ... I am trying to get SUMIFS function to SUM a range of cells only if three criteria are met. I have tried the SUMIFS function for two of the criteria and then added SUMIF to the end for the 3rd criteria, but it always defaults to the SUMIF function even though the first 2 criteria are not met. Example: =SUMIFS(C32:C33,E32:E33,"4",G32:G33,"6")+SUMIF(I32 :I33,"<96",C32:C33) It is adding cells together even when 4 & 6 criteria are not met. Anyone have any ideas! Thank you! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIFS formula using dates and text as criteria | Excel Discussion (Misc queries) | |||
sumifs will not work with a cell reference as criteria | Excel Discussion (Misc queries) | |||
Sumifs - greater than criteria with a Cell Reference | Excel Worksheet Functions | |||
using sumifs to sum based on month, and criteria | Excel Worksheet Functions | |||
Using wildcards in criteria for sumifs functions | Excel Discussion (Misc queries) |