Hi There!!
I've been wracking my brain and I can't seem to get it to work.
Basically I'm trying to create a tracker that will display how many different events per region are happening in the current month (month when the file is opened by others).
Each cell will target a different region and type of event.
For instance
One will focus on Ontario and there are 3 different event types(that are designated by a letter pair, ie. PE, RE, RI) that will each have it's own line for calculation.
Any help would be super helpful, I've tried sumif, countif and haven't been able to get it to work.
Thanks so much!!!!
I've been wracking my brain and I can't seem to get it to work.
Basically I'm trying to create a tracker that will display how many different events per region are happening in the current month (month when the file is opened by others).
Each cell will target a different region and type of event.
For instance
One will focus on Ontario and there are 3 different event types(that are designated by a letter pair, ie. PE, RE, RI) that will each have it's own line for calculation.
Any help would be super helpful, I've tried sumif, countif and haven't been able to get it to work.
Thanks so much!!!!