=SUMIF('A-C 27'!B5:B1000,"A",'A-C 27'!C5:C1000) Have formula need to caculate only 365 days. How would I add this to my formula to current formula listed?
=SUMIF('A-C 27'!B5:B1000,"A",'A-C 27'!C5:C1000) Have formula need to caculate only 365 days. How would I add this to my formula to current formula listed?
Last edited by tmorr24; 09-19-2014 at 10:03 AM. Reason: Added Spreadsheet
It's not particularly clear which of those references contain a date and I didn't see an attachment, so I'll just make one up because I'm fabulous.
=SUMIFS('A-C 27'!C5:C1000,'A-C 27'!F5:F1000,">="&TODAY()-365,A-C 27'!B5:B1000,"A")
In my example, your date is in Column F. Because I'm Fabulous.
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
Now that you've attached an example, I can see that your dates in Column A.
SUMIFS is similar to SUMIF, but the order of arguments is reversed.
=SUMIFS(sum range, criteria range1, criteria1, criteria range2, criteria2, etc)
In your spreadsheet, you left the selection in Column F, so I'll give an example from there.
F5:
=SUMIFS('A-C 27'!$M$5:$M$1300,'A-C 27'!$L$5:$L$1300,"EOP",'A-C 27'!$A$5:$A$1300,">="&TODAY()-365)
If it helps, you can arbitrarily apply line breaks with Alt+Enter to keep things organized.
This formula is no different, but is easier to read:
Please Login or Register to view this content.
Posted in this area also....
http://www.excelforum.com/excel-form...-365-days.html
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
=SUMIFS('A-C 27'!$M$5:$M$1300,'A-C 27'!$L$5:$L$1300,"EOP",'A-C 27'!$A$5:$A$1300,">="&TODAY()-365)
Based on the spreadsheet and the formula I have where would it pull today’s date from? Also, we just started with a new rule. If employee has missed no time for points after 90 days 1 point falls off. Is there a formula that I could add to capture this with a new column? This went into effect 9/1/2014.
The capturing of today's date is done with the function TODAY(). TODAY() will be a different number tomorrow than it is now.
=NOW() = 9/20/2014 13:10
=TODAY() = 9/20/2014
Thank you... I have gotten that fixed. Now I am working on my 90 day formula, however, I still need for it look back anytime someone has received no points in 90 days. I am going to upload my new spreadsheet to reflect this, and maybe you could give me some idea.
New spreadsheet uploaded.
Your most recent attachment is full of broken links
New spreadsheet uploaded
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks