Lookup with multiple conditions

S

Sachin Narute

I have two cells as followes :

A B
1 Sachin Vikas
2 Sachin Amit
3 Sachin Vikas
4 Sachin Vikas

i want to count no of times Sachin and Vikas comes in one row Here ans is
Three.
 
D

Dave Peterson

=sumproduct(--(a1:a4="sachin"),--(b1:b4="vikas"))

is one way.

=sumproduct() wants to work with numbers. -- converts true/false to 0/1.
 
S

Sachin Narute

Thank You Sir,

Regard,

SACHIN

Dave Peterson said:
=sumproduct(--(a1:a4="sachin"),--(b1:b4="vikas"))

is one way.

=sumproduct() wants to work with numbers. -- converts true/false to 0/1.
Click to expand...
 
Top