Trying to sum a spreadsheet by dates

[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

 

[Frank Kabel]

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)

 

[crownluv]

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

 

[Frank Kabel]

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?

 

[crownluv]

Thanks, I sent to your email