=SUM(IF('Personnel-Summary'!$D$6:$D$101='Personnel-Breakdown'!$A8,(IF('Personnel-Summary'!$E$6:$E$101='Personnel-Breakdown'!C$7,1,0)),0))

I am trying to match office location and title from the Personnel-Summary to
fields in the Personnel-Breakdown tab and count the number of matches. As I
said earlier, I get the correct total in the formula bar but a different
number appears when I click 'OK'.

"Stephanie" wrote:

I have a nested formula that I am trying to enter into a cell. When I enter
it into the formula bar, the 'Formula Result' is as I expect but when I hit
'OK', the number displaying in the cell is different and apparently random.
I've tried recalculating, retyping, simplifying (nested IF functions), all to
no avail. The formula bar always looks right and the cell displays wrong.
(It's not a rounding error, I'm trying to get a specific single-digit number
and I get a different single-digit number.)

Help me please!