A Certain Sum Thing

davemacdonald

New member
Joined
Oct 20, 2011
Messages
3
Reaction score
0
Points
0
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!
 

Attachments

  • Workbook1.xls
    14 KB · Views: 22

Canapone

New member
Joined
Oct 3, 2011
Messages
99
Reaction score
0
Points
0
Location
Italy
Excel Version(s)
Excel 2010
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
 
Top