Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for multiple criteria in a column.
Ok, have used this formula to look at two criteria and gives me a sum.
However, if there are more that two criteria in column B, which includes for examples the names of Bill and Dave, how would I alter the formula to pick up the additional name of Dave in column B. =SUMPRODUCT((A1:A5="Feb")*(B1:B5="Bill")*C1:F4) A B C D E F 1 Jan Bill 55 23 24 65 2 Feb Bill 66 22 22 22 3 Feb Dave 55 66 66 34 4 Feb Bill 98 93 54 25 5 Feb Greg 55 66 22 55 -- Bruce |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for multiple criteria in a column.
You are looking for either Bill or Dave, right? Try this formula...
=SUMPRODUCT((A1:A5="Feb")*((B1:B5="Bill")+(B1:B5=" Dave"))*C1:F5) -- Rick (MVP - Excel) "Bruce Benaway" wrote in message ... Ok, have used this formula to look at two criteria and gives me a sum. However, if there are more that two criteria in column B, which includes for examples the names of Bill and Dave, how would I alter the formula to pick up the additional name of Dave in column B. =SUMPRODUCT((A1:A5="Feb")*(B1:B5="Bill")*C1:F4) A B C D E F 1 Jan Bill 55 23 24 65 2 Feb Bill 66 22 22 22 3 Feb Dave 55 66 66 34 4 Feb Bill 98 93 54 25 5 Feb Greg 55 66 22 55 -- Bruce |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I want formula for multiple criteria using ih differnt column | Excel Worksheet Functions | |||
How do I sum column D and F based on multiple column criteria? | Excel Worksheet Functions | |||
FILTERATION ON MULTIPLE CRITERIA OF A COLUMN | Excel Discussion (Misc queries) | |||
Multiple Criteria in same Column | Excel Worksheet Functions | |||
multiple criteria in one column | Excel Worksheet Functions |