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

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

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

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