I have the following formula in a cell:
=SUMPRODUCT(--((J3:J42="Released")+(M3:M42="Released")+
(P3:P42="Released")>0))
It's not doing what it's supposed to do.
I actually have a total of 9 Released cells and it's only
showing a sum of 7.
I noticed that 2 rows out of the above range have more
than one "Released" - It's only adding the total released
if there is only one "Released" in a row and I need to
sum them all.
HELP!
Bookmarks