+ Reply to Thread
Results 1 to 2 of 2

Multiple Criteria Formula Needed

  1. #1
    Registered User
    Join Date
    04-27-2011
    Location
    Sacramento
    MS-Off Ver
    Excel 2007
    Posts
    1

    Multiple Criteria Formula Needed

    I have an aggregate report due to my CEO (its late)

    I am working in 2 different worksheets. 1 is detailed and 1 is a summary. Cells include; Name, total A, total B. My detailed worksheet has multiple listings of the same name with different totals. I am trying to take the sum total A and total B for each name and put this into the summary worksheet for each matched name. (not sure if I can do a screen shot here and/or provided enough information).

    I created a pivot table to sum both totals from the detailed worksheet. I just can get the sum totals to my summary worksheet.

    I have tried DSUM, SUMPRODUCT, COUNTIF, SUMIF.

    Here is the formula I am currently trying:
    .=SUMIF(GrantsList!A7:A460,"Ahmed",GrantsList!C7:C460)

    Can anyone help?

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

    Re: Multiple Criteria Formula Needed

    Hi elcelguru(not) and welcome to the forum.

    I like Pivot Tables but you are trying those. The way to attach a sample sheet is to click on the "Go Advanced" below the message area and click on the Paper Clip Icon above the advanced message area. That will open a window to attach a sample file.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

+ Reply to Thread

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