How to Calculate sum of cells dependent on date range?

General discussion on OpenOffice Calc and its spreadsheets.

How to Calculate sum of cells dependent on date range?

Postby FoxalTO » Thu May 29, 2014 9:27 am

Hi all,
I want to write a formula that will do this for me:
If any of the dates in A14:A33 fall on or between the dates in G8 and G9, then sum the relevant values in I14:I33.
Everything I have tried has failed and returned an error code of some kind. If this kind of thing has been answered
elsewhere,I would appreciate being pointed in the right direction.

thanks.
FoxalTO
 
Posts: 26
Joined: Tue Mar 25, 2014 6:25 am

Re: How to Calculate sum of cells dependent on date range?

Postby UniSET » Thu May 29, 2014 11:35 am

Hi,

I wrote the formula to include the dates in G8 and G9. You can exclude those dates by changing <= and >= to < and >.
Code: Select all
=SUMIFS(I14:I33;A14:A33;">="&G8;A14:A33;"<="&G9)


Hope this will helpful for you
Thanks,
UniSET
 
Posts: 22
Joined: Tue Mar 25, 2014 6:33 am


Return to OpenOffice.org Calc

Who is online

Users browsing this forum: No registered users and 0 guests

cron