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,
![]()
Bookmarks