Conditional summation
 

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",N 25,)+IF
(BA26="y",N26,)...

Conditional summation
 

=sumif(BA23:BA500,"y",N23:N500)

--
Regards,
Tom Ogilvy

"Dale" wrote in message
...
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",N 25,)+IF
(BA26="y",N26,)...

Conditional summation
 

Thanks Tom,I knew there had to be an easy solution.
-----Original Message-----
=sumif(BA23:BA500,"y",N23:N500)

--
Regards,
Tom Ogilvy

"Dale" wrote in
message
...
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",N 25,)
+IF
(BA26="y",N26,)...


.