Named ranges in 2007

[photiniaandpyracantha]

Hi

I had a grid with 4 columns and 6 rows.

In column I had the months Jan through to May. In B, C and D I had product items and I had value of sales against the months.

I had named ranges for rows and columns. Is it possible to calculate the total of 2 products for February sales which are non-contiguous columns using named ranges. I suspect not, but am not sure.

 

[shg]

Welcome to the board.

=sum(range1, range2)

 

[photiniaandpyracantha]

Thank you so much

I am new to Excel 2007 and I just had a mental block. I could see it instantly when you posted your reply.