I'm trying to write a function that will do the following:
If the date in column C is in the last 90 days, average the value in column H.
I think I'm having an issue because column H is the difference in days between column C and another column. Any help would be appreciated!
Last edited by ptho16; 08-16-2012 at 09:57 AM.
Try
=AVERAGEIFS(H:H,C:C,"<="&TODAY(),C:C,">="&TODAY()-90)
I'm not totally clear on what you're asking but it sounds like you want to average the column H, but only the values in rows where C falls within 90 days of now?
Try this:
=Average(If(Today()-C1:C100<90),H1:H100,FALSE))
But instead of hitting, Enter, hit Ctrl+Shift+Enter, this is an array function.
AverageIfs will do the trick as well
I get the #DIV/0! error, any ideas? both columns are populated with data.
You should only see that if there are no rows that meet the criteria. Did you try both suggestions?
you're correct, I'm an idiot, i've got to increase the 90 days.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks