SUMPRODUCT w/ 3 criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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
 
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
 
Back
Top