Home |
Search |
Today's Posts |
#1
|
|||
|
|||
sumif with 2 criteria
I am trying to sum a column that needs to meet 2 criteria and am not sure how
to create it - any help would be GREAT!! |
#2
|
|||
|
|||
Hi Jamie
use the SUMPRODUCT function =SUMPRODUCT(--(Range1=Criteria1),--(Range2=Criteria2),RangetoSum) e.g. =SUMPRODUCT(--(A1:A100="Big"),--(B2:B100="Blue"),C1:C100) check out http://www.xldynamic.com/source/xld.SUMPRODUCT.html for more details on how this function works. Cheers JulieD "Jamie" wrote in message ... I am trying to sum a column that needs to meet 2 criteria and am not sure how to create it - any help would be GREAT!! |
#3
|
|||
|
|||
Hi
use SUMPRODUCT. See: http://www.xldynamic.com/source/xld.SUMPRODUCT.html -- Regards Frank Kabel Frankfurt, Germany "Jamie" schrieb im Newsbeitrag ... I am trying to sum a column that needs to meet 2 criteria and am not sure how to create it - any help would be GREAT!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF Criteria | Excel Discussion (Misc queries) | |||
SUMIF with only one criteria cell within range | Excel Discussion (Misc queries) | |||
SUMIF multiple criteria | Excel Worksheet Functions | |||
Can I use a cell reference in the criteria for the sumif function. | Excel Worksheet Functions | |||
sumif 2 criteria | Excel Worksheet Functions |