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
|