Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMPRODUCT not recognising dates
Hi.
I have a spreadsheet that imports data from an Access query. The query has 3 columns - date of purchase, profit & whether the product was new(N) or used(U). It has grouped the information by month, so the spreadsheet looks like this: Column A Column B Column C DealDate Profit NewUsed January 2007 £50,000 N January 2007 £30,000 U February 2007 £60,000 N February 2007 £45,000 U etc... What I want to happen is to be able to key in a date (ie 01/02) in cell G2 and to have 2 other cells showing the New & Used profit for that month: £60,000 & £45,000. If I use SUMIF, it recognises column A as a date, but I can't get it to split the monthly total (I get £105,000) If I use SUMPRODUCT, it doesn't recognise column A as a date but as text and instead of typing in 01/02 in G2, I have to type on 'February 2007. =SUMPRODUCT(--(A1:A500=G2),--(C1:C500="N"),(B1:B500)) Is there anyway of getting SUMPRODUCT to recognise the data in column A as a date instead of text? Many thanks Del. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumproduct between dates | Excel Worksheet Functions | |||
Excel copied cells not recognising date formats | Excel Discussion (Misc queries) | |||
sumproduct with dates | Excel Worksheet Functions | |||
VLookup not recognising numbers | Excel Worksheet Functions | |||
sumproduct between dates | Excel Worksheet Functions |