Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sum if w. 2 criteria
I have columns in a sheets that I am trying to add sales of one column if
they meet two criteria - Column C=north and Column J=1 then I want to add all sales. Help!! |
#2
|
|||
|
|||
Hi
try =SUMPRODUCT(--(C1:C100="north"),--(J1:J100=1),K1:K100) if column K contains your sales values. Also see: http://www.xldynamic.com/source/xld.SUMPRODUCT.html -- Regards Frank Kabel Frankfurt, Germany "Jamie" schrieb im Newsbeitrag ... I have columns in a sheets that I am trying to add sales of one column if they meet two criteria - Column C=north and Column J=1 then I want to add all sales. Help!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Wildcard Selection Criteria | Excel Discussion (Misc queries) | |||
SUMIF with only one criteria cell within range | Excel Discussion (Misc queries) | |||
sumif with 2 criteria | Excel Worksheet Functions | |||
How do I get the COUNTIF criteria to recognize only month and yea. | Excel Worksheet Functions | |||
Can I use a cell reference in the criteria for the sumif function. | Excel Worksheet Functions |