Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help with sumproduct formula
I was given this formula =SUMPRODUCT(--(E2:E10="Dawn"),--(F2:F10="X"))
yesterday which worked perfectly. I tried to apply a "date" to one of columns as a "name" but it does display the correct total. I need to know how many times "8/11" in column B and "West" in column D are in the same row. Thank you in advance for your help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help with sumproduct formula
Is "8/11" a valid date?
Use cells to hold the criteria: A1 = 8/11 A2 = west =SUMPRODUCT(--(B2:B10=A1),--(D2:D10=A2)) -- Biff Microsoft Excel MVP "Nielly" wrote in message ... I was given this formula =SUMPRODUCT(--(E2:E10="Dawn"),--(F2:F10="X")) yesterday which worked perfectly. I tried to apply a "date" to one of columns as a "name" but it does display the correct total. I need to know how many times "8/11" in column B and "West" in column D are in the same row. Thank you in advance for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMPRODUCT Formula | Excel Discussion (Misc queries) | |||
Nesting a sumproduct formula within a sumif formula. | Excel Discussion (Misc queries) | |||
sumproduct formula | Excel Worksheet Functions | |||
Help - Looking for a Sumproduct formula | Excel Worksheet Functions | |||
Sumproduct Formula | Excel Worksheet Functions |