Good morning gurus,
got a column of dates;
got a column of boring numbers next to it.
Is there an elegant way to write a formula that uses SUMIFS to sum up some values (just numbers) when I give two dates--just sum the numbers at and within those dates?
SUMIFS() should do that
assuming column A = date
Column B to sum
=SUMIFS( B1:B100 , A1:A100 , ">="& date , "<="& date )
A sample sheet would help - see yellow banner
you can use cells with the required dates in or hardcode in the function
Not sure why your title says SUMIFS & and an AND - maybe more to the question then i understand, hence suggested spreadsheet
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
SUMIFS is, effectively, ANDing conditions together. For example,Formula:
Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
DISREGARD, it was quite obvious after some work.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks