Hi.
I have this IF() formula:
=IF($AJ6+$AI6 <= AG5, 1, 0)
How do I SUM all within $AI6:$AI178+$AJ6:$AJ178, relatively speaking, like so:
IF $AJ6 + $AI6 <= AG5 THEN count 1
IF $AJ7 + $AI7 <= AG5 THEN count 1
all the way to...
IF $AJ177 + $AI178 <= AG5 THEN count 1
IF $AJ178 + $AI178 <= AG5 THEN count 1
and then getting the total SUM?
PR
Bookmarks