Hello,
I've attached a spreadsheet that has a sample Page 1 and Page 2. I'd like the data to be entered into Page 1 as described and then a sum occur on Page 2. I've highlighted the cells where I'd like the sum to occur.
Any ideas?
Cheers!
Hi,
maybe in C6 something like:
=Sumif($C$2:$AA$2,C5,$B$2:$Z$2)
to be copied below the categories (in C5, E5...)
Just an attempt
Regards
Bookmarks