That worked for that but it broke another formula...i had in another cell
when i enter the =MOD formula in the Q cell...![]()
=SUMPRODUCT(('June 08'!B269:'June 08'!B915=3070)*('June 08'!Q269:'June 08'!Q915<>0))
Now on the broken formula i am getting #VALUE! as an error
Bookmarks