Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nesting SUMIF
I need to sum a column but only if 2 criteria are met. criteria is in 2
different columns. I am having problems nesting SUMIF - any suggestions? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nesting SUMIF
Use SUMPRODUCT
=SUMPRODUCT((A1:A999="whatever")*(B1:B999="somethi ng");D1:D999) HTH -- AP "360Kid" a écrit dans le message de news: ... I need to sum a column but only if 2 criteria are met. criteria is in 2 different columns. I am having problems nesting SUMIF - any suggestions? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nesting SUMIF
try
=sumproduct((a2:a22="joe")*(b2:b22=2)*c2:c22) -- Don Guillett SalesAid Software "360Kid" wrote in message ... I need to sum a column but only if 2 criteria are met. criteria is in 2 different columns. I am having problems nesting SUMIF - any suggestions? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nesting SUMIF
Try something like this:
=SUMPRODUCT((A1:A10=criteria1)*(B1:B10=criteria2)* C1:C10) That formula adds values from Col_C where Col_A matches the first criteria and Col_B matches the second criteria. Example: =SUMPRODUCT((A1:A10="active")*(B1:B10="employee")* C1:C10) Is that something you can work with? *********** Regards, Ron XL2002, WinXP "360Kid" wrote: I need to sum a column but only if 2 criteria are met. criteria is in 2 different columns. I am having problems nesting SUMIF - any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
Nesting SUMIF formulas | Excel Worksheet Functions | |||
Sumif of Sumif perhaps? | Excel Discussion (Misc queries) | |||
Nesting of sumif formula. | Excel Worksheet Functions | |||
Nesting Sumif function | Excel Worksheet Functions |