Results 1 to 2 of 2

Thread: A Certain Sum Thing

  1. #1

    Question A Certain Sum Thing



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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!
    Attached Files Attached Files

  2. #2
    Acolyte Canapone's Avatar
    Join Date
    Oct 2011
    Location
    Italy
    Posts
    97
    Articles
    0
    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

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •