values within a range

[wave_gr]

Version: 2008
Operating System: Mac OS X 10.4 (Tiger)
Processor: Intel

Hello,

Can you please help me. I need to calculate the sum of values within a certain monthday range during sveral years, and can't find a formula.

So in 1 colimn i have values, in the 2 the number of day of the month (calculated with= DAY(date)). And I want the programme to chose the values in the 1st one within day 15 and 24 of a certain month, for each year. And finally sum the up. How can I do this?

Thank you.

 

[JE McGimpsey]

Version: 2008
Operating System: Mac OS X 10.4 (Tiger)
Processor: Intel

Hello,

Can you please help me. I need to calculate the sum of values within a
certain monthday range during sveral years, and can't find a formula.

So in 1 colimn i have values, in the 2 the number of day of the month
(calculated with= DAY(date)). And I want the programme to chose the values in
the 1st one within day 15 and 24 of a certain month, for each year. And
finally sum the up. How can I do this?

You may be able to use SUMPRODUCT(), but since you didn't explain how to
find the certain month and year, it's hard to be sure.

It's also probable that using a pivot table would be an easier way to
summarize your data.

How is the other information laid out?