Results 1 to 4 of 4

Need column with subtotal of multiple criteria groups

Threaded View

  1. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,227

    Re: Need column with subtotal of multiple criteria groups

    Hi markmellow and welcome to the forum.

    See the attached with your answer which takes a SumIf formula.

    I see my formula used a SumIf and worked for the first few rows but use the SUMIFS() formula given below by day92 and he got the problem right.

    My BAD! Yeah for day92's formula. See it below.
    Attached Files Attached Files
    Last edited by MarvinP; 08-01-2012 at 09:20 PM.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1