Conditional summation

[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,)...

 

[Tom Ogilvy]

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

 

[Dale]

Thanks Tom,I knew there had to be an easy solution.