Hi everyone

I have been using the following formula
=SUMPRODUCT(($D$2:$D$576=T39)*($P$2:$P$576="Yes"))

which has been working well on all other columns ie M instead of P however
using P the result shows as 2 (when you step through it) which is correct but
when you hit enter the cell goes back to 0 - very strange - have checked
format etc and all looks ok. any thoughts on this one please?
--
Thanks as always

Lise