D
Dale
I'm trying to sum a column of numbers but I only want to
add numbers where a condition is satisfied. The condition
increments with the row. I can manualy grunt through the
equation but there is a limit on how long the formula can
be. Is there a way to increment a condition in a SUM?
Specifically, the equation would look like this:
=IF(BA23="y",N23,)+IF(BA24="y",N24,)+IF(BA25="y",N25,)+IF
(BA26="y",N26,)...
add numbers where a condition is satisfied. The condition
increments with the row. I can manualy grunt through the
equation but there is a limit on how long the formula can
be. Is there a way to increment a condition in a SUM?
Specifically, the equation would look like this:
=IF(BA23="y",N23,)+IF(BA24="y",N24,)+IF(BA25="y",N25,)+IF
(BA26="y",N26,)...