Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dates formula problem
I am using excel 2003.
I tried to get my sales per quarter in one cell, so I have two columns, one for the date, the other one is my sales revenues. I dont have problem with one argument, but I dont know how to integrate the second argument. If I applied this function in my cell: =SUMIF(C24:C300,"=39172",D24:D300) it works for all date since 39172. But how can I integrate: and =<39172. to get sales from my first quarter. You understand that I worked with the numbers of day since 1900, because I dont know, how to use date value formula. -- Any suggestions would be greatly appreciated. Andre |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dates formula problem
Hellowa
=SUMIF(C24:C300,"="&A1,D24:D300) In A1, put a date. Eg. if you want to sum sales in a period, use =SUMIF(C24:C300,"="&A1,D24:D300)-SUMIF(C24:C300,""&A2,D24:D300) where A1 holds first day of the period, A2 the last day. -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music " wrote: I am using excel 2003. I tried to get my sales per quarter in one cell, so I have two columns, one for the date, the other one is my sales revenues. I dont have problem with one argument, but I dont know how to integrate the second argument. If I applied this function in my cell: =SUMIF(C24:C300,"=39172",D24:D300) it works for all date since 39172. But how can I integrate: and =<39172. to get sales from my first quarter. You understand that I worked with the numbers of day since 1900, because I dont know, how to use date value formula. -- Any suggestions would be greatly appreciated. Andre |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dates formula problem
Thank you so much, it's work.
-- Any suggestions would be greatly appreciated. Andre "Wigi" wrote: Hellowa =SUMIF(C24:C300,"="&A1,D24:D300) In A1, put a date. Eg. if you want to sum sales in a period, use =SUMIF(C24:C300,"="&A1,D24:D300)-SUMIF(C24:C300,""&A2,D24:D300) where A1 holds first day of the period, A2 the last day. -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music " wrote: I am using excel 2003. I tried to get my sales per quarter in one cell, so I have two columns, one for the date, the other one is my sales revenues. I dont have problem with one argument, but I dont know how to integrate the second argument. If I applied this function in my cell: =SUMIF(C24:C300,"=39172",D24:D300) it works for all date since 39172. But how can I integrate: and =<39172. to get sales from my first quarter. You understand that I worked with the numbers of day since 1900, because I dont know, how to use date value formula. -- Any suggestions would be greatly appreciated. Andre |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
dates problem | Excel Discussion (Misc queries) | |||
Dates Problem | Excel Discussion (Misc queries) | |||
Problem with dates | Excel Discussion (Misc queries) | |||
Problem Dates | Excel Discussion (Misc queries) | |||
Conditional formatting with dates formula problem. | Excel Discussion (Misc queries) |