Results 1 to 3 of 3

Sum with two conditions

Threaded View

  1. #1
    Registered User
    Join Date
    10-19-2008
    Location
    UK
    Posts
    63

    Sum with two conditions

    Hi,

    I have some of data contained in cells A4:C13.
    First column A4:A13 has dates. Please note these can repeat themselves eg. A1 = 01/02/2012 and also A2 = 01/02/2012.
    Second column B4:B13 I have fruit name eg. apples, cherries and pears.
    Third column C4:C13 I have numbers

    I would like to do a SUM of pears for a specific date say 03/02/2012.
    The formula with SUM would appear in Cell A2.

    VLOOKUP does not seem to work as dates are repeated so condition does not work.
    Lets' say we have three dates with 03/02/2012 in Cells A8, A9 and A10.
    Fruit pears is in Cell B9

    What formula should I write in A2 so I have number of pears in Cell C9?

    Thanks,
    Last edited by NBVC; 03-05-2012 at 03:14 PM.

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