G
Guest
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 don’t have problem with one argument, but I don’t know how to integrate
the second argument.
If I applied this function in my cell: =SUMIF(C24:C300,">=39172",D24300)
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
don’t know, how to use date value formula.
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 don’t have problem with one argument, but I don’t know how to integrate
the second argument.
If I applied this function in my cell: =SUMIF(C24:C300,">=39172",D24300)
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
don’t know, how to use date value formula.