markster
Well-known Member
- Joined
- May 23, 2002
- Messages
- 579
- Office Version
- 365
- Platform
- Windows
- MacOS
Hello
I'm using the following COUNTIF Formula.
=COUNTIF('Staff Mapping v0.4'!$D$4:$D$119,Summary!C4)
I need to add an additional criteria that only counts the value in C4 if Staff Mapping v0.4 worksheet contains the word "Matched" in column I
Can anyone help?
Cheers
Mark
I'm using the following COUNTIF Formula.
=COUNTIF('Staff Mapping v0.4'!$D$4:$D$119,Summary!C4)
I need to add an additional criteria that only counts the value in C4 if Staff Mapping v0.4 worksheet contains the word "Matched" in column I
Can anyone help?
Cheers
Mark