Hi.
I need some help. I am working on an excel document and can't figure out how to do the proper formula for what I am needing.
On Sheet 1, in cells C7-22 I have dates listed (ex. July 15, August 12, etc.), D7-22, I have reasons (vacation, academic leave, etc.) and in E7-22, I have numbers.
If a date contains the word July for example, and in D has vacation, I want it to add up any numbers that would correspond with those dates on to Sheet 2 of my Excel document.
How do I do this!?!?
Is it even possible?
Bookmarks