i have some defined ranges within a sumproduct formula to determine a percentage of cells that are on time (not late).
however, if cells in _Rng2 are blank i need it to state 0% rather than 100%Please Login or Register to view this content.
formulae for defined ranges below if necessary
_Rng1
_Rng2Please Login or Register to view this content.
Please Login or Register to view this content.
Bookmarks