Trying to sum a spreadsheet by dates

  • Thread starter Thread starter crownluv
  • Start date Start date
C

crownluv

Is there a way to sum an entire spreadsheet, only if it's within certai
date, i.e. 4/1-4/15, 4/16-4/30?

I was able to do one row, after messing around with it, but I can'
figure out how to get it to filter the entire spreadsheet.

Thanks, in advance, for any help you can give
 
Hi
what dou you mean with 'entire spreadsheet' and where are the dates
stored?
If you mean you have dates in column a and values in column B you may
use something like the following
=SUMPRODUCT(--(A1:A1000>=DATE(2004,4,1)),--(A1:A1000<=DATE(2004,4,15)),
B1:B1000)
 
Hi.

I have dollar amounts in rows f-i, k and l. I will have numerou
entries throughout the month. I want to be able to see how much incom
I made through the first half of the month, and then the second half
separate from the total. Just wondering if it can be totaled using th
date in row c.

Thanks again for your help.

P.S. I'm not sure if I'm allowed to post my file here so you can hav
an idea of what I'm doing
 
Hi
don't attach a file to this NG. you may email me this privately:
frank[dot9kabel[at]freenet[dot]de

but have you tried the SUMPRODUCT function?
 
Back
Top