Countif

[Jan Kalop]

What the formula would look like to preform task like that:


if i column A1:A50 any number equal to 3 then look i column D1:D50 and count cells with number 15

 

[VoG]

Try

=SUMPRODUCT(--(A1:A50=3),--(D1:D50=15))

 

[Robert Mika]

=COUNTIFS(A1:A50,3,D1:D50,15)
Excel 07/10/13

 

[Jan Kalop]

Working 100%
Thanks a lot.

 

[Robert Mika]

Working 100%
Thanks a lot.

You are welcome.