SUMPRODUCT w/ 3 criteria

[Guest]

Hi all,
When I use:
=SUMPRODUCT(($B$18:$B$840=$A8)*(O$18:O$840>=O$8)*(P$18$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

 

[Guest]

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

 

[Peo Sjoblom]

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

 

[Guest]

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