+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 : Multi Conditional Sum

  1. #1
    Registered User
    Join Date
    08-25-2010
    Location
    Birmingham
    MS-Off Ver
    Excel 2003
    Posts
    44

    Multi Conditional Sum

    Hi

    Try to explain...could do with some help please

    I have 2 sum if statements if you like that i need to bring togeather and them calulate a summary of a certain colounm if it matches the criteria.

    I have it like this

    Col A Col B Col C
    Brand Month Revenue

    What i need it to do is IF IT = a certain brand AND a certain month then add togeather the revenue from COL C.

    Im using this at the moment that adds togeather the revenue from picking up the 'brand'
    =SUMIF('Input data'!$A$7:$D$321,"Climate",'Input data'!$AC$7:$AC$321)

    But as i said above i need it to pick up the brand, then the month, then add togeather the Revenue any help would be GREAT!!!!!!!!!! thanks very much

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Multi Conditional Sum

    please do not post the same question more than once

    http://www.excelforum.com/excel-2007...ional-sum.html

    please read the Forum Rules before posting further.

    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