Results 1 to 8 of 8

Excel 2007 : Multi Conditional Sum

Threaded View

  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
    Last edited by jesz1987; 10-14-2010 at 06:29 AM.

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