I am using this formula to calculate for a specific date (E1) but want to be able to calculate between 2 dates (E1-F1) and 7 days before and/or after (E1).
=SUMIFS(Metrics!F:F,Metrics!D:D,A6,Metrics!A:A,E1)
I am using Excel 2010
Thanks
I am using this formula to calculate for a specific date (E1) but want to be able to calculate between 2 dates (E1-F1) and 7 days before and/or after (E1).
=SUMIFS(Metrics!F:F,Metrics!D:D,A6,Metrics!A:A,E1)
I am using Excel 2010
Thanks
Last edited by Cassi; 03-27-2013 at 02:00 PM.
I'm not sure exactly what you are asking for (or how your data is set up) but from your formula, this should Sum F if the date in A is between E1 and F1 (and the value in D is equal to A6). Does that help?
=SUMIFS(Metrics!F:F,Metrics!D:D,A6,Metrics!A:A,">="&E1, Metrics!A:A, "<="&F1)
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks