A Certain Sum Thing

[davemacdonald]

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!

[Canapone]

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