Forum Discussion
Countif new problem
Hello everyone,
I start to be crazy with this formula, I take information from the file I working on to show you my problem. Can you take a look on my file and give me your feedback.
Thank you in advance for your help.
Anyone? My problem is that the formula give me 0 everytime.
I really need your help, I'm lost of why.
Thank you.
Kevin,
you didn't use relativ cell references for column G.
=COUNTFIS($A:$A,$F$6,$B:$B,$G6,$D:$D,H$5)
Since I'm lazy I would have used a pivot table.
No hassel with formulas and cellreferences.
