hmltnangel
Active Member
- Joined
- Aug 25, 2010
- Messages
- 290
- Office Version
- 365
- Platform
- Windows
OK, so I know this is going to be one of those reallllllly silly errors Im making. But I cant see the wood for the trees.
I have a COUNTIFS, that I am asking to count the mount of times an Employee ID matches, and the amount of times a value matches another cell.
The employee id matches fine, but its not counting the cell match value. So, I broke it down and said a simple formula like this.
=IF([@Goal]=$U$8,"LV","") This simply has a blank for every answer. I suspect its the way the [@GOAL] Value is written in $U$8 as per below, or maybe the number of character at 1129?
BLAH BLAH -
blah blahblah:
Blah 1- blah blah.
blah 2 - blah blah.
blah 3 - blah blah.
blah 4 - blah blah.
blah 5 - blah blah.
blah 6 - blah blah
ANy ideas?
I have a COUNTIFS, that I am asking to count the mount of times an Employee ID matches, and the amount of times a value matches another cell.
The employee id matches fine, but its not counting the cell match value. So, I broke it down and said a simple formula like this.
=IF([@Goal]=$U$8,"LV","") This simply has a blank for every answer. I suspect its the way the [@GOAL] Value is written in $U$8 as per below, or maybe the number of character at 1129?
BLAH BLAH -
blah blahblah:
Blah 1- blah blah.
blah 2 - blah blah.
blah 3 - blah blah.
blah 4 - blah blah.
blah 5 - blah blah.
blah 6 - blah blah
ANy ideas?