Hi
please could someone assist with the below
in columns A:A i have dates,
in columns J:J i have numbers ranging from 1-1000
i would like a formula to sum J:J, where the date is today & up to 5 workdays old using A:A
thanks
Hi
please could someone assist with the below
in columns A:A i have dates,
in columns J:J i have numbers ranging from 1-1000
i would like a formula to sum J:J, where the date is today & up to 5 workdays old using A:A
thanks
Last edited by papasmurfuo9; 04-15-2014 at 08:17 AM.
Assuming the date could be greater than today
Try
=SUMIFS($J1:$J10000, $A$1:$A$10000, ">= "&TODAY()-5, $A$1:$A$10000, "<=" & TODAY())
Set up your ranges accordingly.
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
hi
almost perfect
however i need it to be the last 5 working days, and not just day
this possible? thanks
Assuming the workdays are Mon thru Fri...
=SUMIFS(J:J,A:A,">="&WORKDAY(NOW(),-5),A:A,"<="&TODAY())
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks