SUMIF help!

New Contributor

Hey all!

I'm building a spreadsheet to calculate available pto and I need help.

I have two sheets one that holds the calculator and one with a calendar input to add scheduled time off, my goal is calculate a total of time off but only if that time falls after today's date to get an accurate count of how much time I would have available. 

Ex: sumif(b2:b366, IFA2:A366 '>='TODAY)

But I can't quite figure out how to make this work, any help would be greatly appreciated!

2 Replies
best response confirmed by srebmahceoj (New Contributor)


=SUMIF( A2:A366,">="&TODAY(),B2:B366)

Maybe like this. 

You're my absolute hero! I couldn't possibly figure out where I'd gone wrong