stevenhunter88
New Member
- Joined
- Jun 8, 2021
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
Good afternoon!
I have a formula that I need a little bit of help with.
Background: I count total number of instances that I place services calls for in a given month, and for different locations. Currently, my formula works like this:
=SUMPRODUCT(--(ISNUMBER(F28:F100)),--(MONTH(F28:F100)=1))
It has worked well for one location, however we have now added additional located that I need it to also differentiate. The location is stored in the adjacent cell, so for example, I want the month counted if the cell adjacent to it says: "Hospital", however I do not want to count it if it does not. Is there a way that I can do this as the formula I have set up now? I have scoured around and have worked on this for a while and cannot seem to get it.
Thank you in advance!
I have a formula that I need a little bit of help with.
Background: I count total number of instances that I place services calls for in a given month, and for different locations. Currently, my formula works like this:
=SUMPRODUCT(--(ISNUMBER(F28:F100)),--(MONTH(F28:F100)=1))
It has worked well for one location, however we have now added additional located that I need it to also differentiate. The location is stored in the adjacent cell, so for example, I want the month counted if the cell adjacent to it says: "Hospital", however I do not want to count it if it does not. Is there a way that I can do this as the formula I have set up now? I have scoured around and have worked on this for a while and cannot seem to get it.
Thank you in advance!