| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to pull <=14 Days, <=30 Days, 30 Days from a date column | Excel Discussion (Misc queries) | |||
| Employee days worked (-Holidays, -weekends, Snow Days, etc) | Excel Discussion (Misc queries) | |||
| Calc days between two dates and exclude leap year days | Excel Worksheet Functions | |||
| Conditional Formatting Dates calculating 10 days and 30 days from a certain date | Excel Worksheet Functions | |||
| COUNT how many ROWS ago out of 10 days that the highest high in 10 days was made | Excel Worksheet Functions | |||
Linear Mode
