PDA

View Full Version : A Certain Sum Thing



davemacdonald
2012-01-19, 07:04 AM
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
2012-01-19, 09:04 AM
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