Summing Data based on certain criteria

[Howardc]

Create a new Defined Name that consist of the entire rows of 3:5,7,11:12 and name it OI (short for Other Income), then try this formula (those single spaces between OI and the column designations are on purpose)...

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

Hi Rick

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

Regards

Howard