Count formula for 3 or more condtion

[manoj_arsul]

can any one send me the formula for .
1) Match 1nd condition with Column "A"
2) Match 2nd condition with column "B"
3) Match 3rd condition with Column "C"
4) Result is column count in cell "D1"

I having a formula for the same but its working only for 2 column =COUNTIFS(A:A, G7,B:B, "="&TODAY()-1)
A:A, G7 - First condition
B:B, "="&TODAY()-1) - Second condition

I want add one more (3rd) condition ie. for C:C, "specific Text" .

 

[jtakw]

Hi,

May be I'm missing something,

wouldn't you just add your 3rd requirement in your formula?

=COUNTIFS(A:A,G7,B:B,"="&TODAY()-1,C:C,"specific text")