Summing Data based on certain criteria

[Rick Rothstein]

Hi Rick

Thanks for the help, much appreciated. First time I've come accross this formula-very clever

Two ranges separated by a single space returns the intersection of the two ranges. And, now that I think of it some more, we can take advantage of the fact that Columns I and J are contiguous and shorten the formula to this...

=SUM(OI F:F,OI I:J)

And, of course, instead of using my OI defined name, you can simply change your Other_Income defined name to be the entire rows and use that in place of my OI if you are not using Other_Income anywhere else in your workbook.