Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMPRODUCT w/ 3 criteria
Hi all,
When I use: =SUMPRODUCT(($B$18:$B$840=$A8)*(O$18:O$840=O$8)*( P$18:P$840<=P$8*$P$4)) my results is DIV $P$4= .80 col A col B col O col P 67.9%(O$8) 74.5%(P$8) Reg 1 Reg 1 71.0% 44.3% Reg 2 Reg 1 54.8% 89.1% Reg 3 Reg 1 89.3% 39.8% I would have expected a result of 2 but rpesume I have written my formula wrong... please help thanks! jane |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMPRODUCT w/ 3 criteria
Could you explain what you are trying to accomplish?
-- If this reply was helpful, please indicate that your question has been answered to help others find anwsers to similar questions. www.silverbirddesigns.com Fighting Texas Aggie Class of 2009 "jane" wrote: Hi all, When I use: =SUMPRODUCT(($B$18:$B$840=$A8)*(O$18:O$840=O$8)*( P$18:P$840<=P$8*$P$4)) my results is DIV $P$4= .80 col A col B col O col P 67.9%(O$8) 74.5%(P$8) Reg 1 Reg 1 71.0% 44.3% Reg 2 Reg 1 54.8% 89.1% Reg 3 Reg 1 89.3% 39.8% I would have expected a result of 2 but rpesume I have written my formula wrong... please help thanks! jane |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMPRODUCT w/ 3 criteria
Most likely you have a DIV error somewhere in your data in column O or P, if
you have text you would a get VALUE error but this formula can only return a DIV/0 error if there are errors already in your data -- Regards, Peo Sjoblom "jane" wrote in message ... Hi all, When I use: =SUMPRODUCT(($B$18:$B$840=$A8)*(O$18:O$840=O$8)*( P$18:P$840<=P$8*$P$4)) my results is DIV $P$4= .80 col A col B col O col P 67.9%(O$8) 74.5%(P$8) Reg 1 Reg 1 71.0% 44.3% Reg 2 Reg 1 54.8% 89.1% Reg 3 Reg 1 89.3% 39.8% I would have expected a result of 2 but rpesume I have written my formula wrong... please help thanks! jane |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMPRODUCT w/ 3 criteria
what does Homer Simpson day??? DOH!
of course you are right Peo... I think it is time to pack up the ole' laptop and go hoem for the day! thanks, jane "Peo Sjoblom" wrote: Most likely you have a DIV error somewhere in your data in column O or P, if you have text you would a get VALUE error but this formula can only return a DIV/0 error if there are errors already in your data -- Regards, Peo Sjoblom "jane" wrote in message ... Hi all, When I use: =SUMPRODUCT(($B$18:$B$840=$A8)*(O$18:O$840=O$8)*( P$18:P$840<=P$8*$P$4)) my results is DIV $P$4= .80 col A col B col O col P 67.9%(O$8) 74.5%(P$8) Reg 1 Reg 1 71.0% 44.3% Reg 2 Reg 1 54.8% 89.1% Reg 3 Reg 1 89.3% 39.8% I would have expected a result of 2 but rpesume I have written my formula wrong... please help thanks! jane |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumproduct and IF criteria?? | Excel Discussion (Misc queries) | |||
SUMPRODUCT - 2 Criteria | Excel Worksheet Functions | |||
Sumproduct - two+ criteria | Excel Worksheet Functions | |||
Sumproduct 4 criteria | Excel Worksheet Functions | |||
Sumproduct with 2 criteria | Excel Worksheet Functions |