COUNTIFS Formula Problem
On Sep 18, 5:38 pm, Jim wrote:
Has anyone experienced any substantial errors from theCountifsFormula?
A B C
1 15 51 30
3 20 30 18
4 20 15 18
5 15 51 30
COUNTIFS(A3:C3,A1,A4:C4, B1,A5:C5, C1) = 0 when it should equal 1
Is my syntax wrong? This what the formula produces?
Any ideas?
I have a similar problem, which I thought I posted earlier today. I
have the following cells:
a b c
1 2/15/08
countifs(a1,""&today(),b1,"="&"")
Cell c1 returns 0 instead of 1. Any ideas?
|