Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Jan 2003
    Location
    Greeley, Colorado
    Posts
    188
    Thanks
    8
    Thanked 1 Time in 1 Post
    I have a spreadsheet that looks like below. I want totals by the second column but don't want to group them (which of course makes easy totaling). I want them intermixed.
    Item1 Actual 100
    Item2 SOW 200
    Item3 Actual 300
    Item4 SOW 400

    Total Actual 400
    Total SOW 600

    How do I make the last two rows happen?

  2. #2
    New Lounger
    Join Date
    Dec 2009
    Location
    Woodbury, GA
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts
    First I named the columnar data ranges to make the formulas more concise. *For the items I chose "Items"; for Actual and SOW I chose "Category"; and finally for the amounts I used "Amounts".

    For Total Actual I used =Sumif(Items,"Actual", Amounts) to arrive at the answer.

    For Total SOW I used =Sumif(Items,"Actual", Amounts).

  3. #3
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,434
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Quote Originally Posted by Mark Trevithick View Post
    For Total SOW I used =Sumif(Items,"Actual", Amounts).
    Mark,

    I think you wanted to type: For Total SOW I used =Sumif(Items,"SOW", Amounts).

    I have the same problem the brain gets ahead of the fingers!
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  4. #4
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    Hi All - I think Mark's formulas were meant to be what is shown in his Pic above in D12 and D13......

    =SUMIF(Category,"Actual",Amounts)
    =SUMIF(Category,"SOW",Amounts)

    The pic below shows Mark's way (Rows 12 and 13) and an alternative (Rows 9 and 10).
    There are other alternatives to achieve the same answer.

    Attached Images Attached Images

Posting Permissions

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