Sum for last 90 days
 

I have a spreadsheet with column H = date and column J is a numerical
value. I am looking for a way to sum all entries in the last 90 days.

I've been using this formula that counts months but I want to go by
days to get a more accurage total.

=SUMIF(H:H,""&DATE(YEAR(TODAY()),MONTH(TODAY())-3,DAY(TODAY())),J:J)

Can anyone help me with this?

Jim

Sum for last 90 days
 

=SUMIF(H:H,""&TODAY()-90,J:J)

--
Regards,
Tom Ogilvy



wrote in message
oups.com...
I have a spreadsheet with column H = date and column J is a numerical
value. I am looking for a way to sum all entries in the last 90 days.

I've been using this formula that counts months but I want to go by
days to get a more accurage total.

=SUMIF(H:H,""&DATE(YEAR(TODAY()),MONTH(TODAY())-3,DAY(TODAY())),J:J)

Can anyone help me with this?

Jim

Sum for last 90 days
 

Hi Jim,

I think that the condition can be expressed as

=SUMIF(H:H,""&TODAY()-90,J:J)

Anthony

" wrote:

I have a spreadsheet with column H = date and column J is a numerical
value. I am looking for a way to sum all entries in the last 90 days.

I've been using this formula that counts months but I want to go by
days to get a more accurage total.

=SUMIF(H:H,""&DATE(YEAR(TODAY()),MONTH(TODAY())-3,DAY(TODAY())),J:J)

Can anyone help me with this?

Jim

Sum for last 90 days
 

Thanks that works great!

Anthony D wrote:
Hi Jim,

I think that the condition can be expressed as

=SUMIF(H:H,""&TODAY()-90,J:J)

Anthony

" wrote:

I have a spreadsheet with column H = date and column J is a numerical
value. I am looking for a way to sum all entries in the last 90 days.

I've been using this formula that counts months but I want to go by
days to get a more accurage total.

=SUMIF(H:H,""&DATE(YEAR(TODAY()),MONTH(TODAY())-3,DAY(TODAY())),J:J)

Can anyone help me with this?

Jim