ExcelBanter - Lookup with multiple conditions

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Lookup with multiple conditions (https://www.excelbanter.com/excel-discussion-misc-queries/38017-lookup-multiple-conditions.html)

Sachin Narute

Lookup with multiple conditions

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.

Dave Peterson

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

is one way.

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

Sachin Narute wrote:

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.

--

Dave Peterson

Sachin Narute

Thank You Sir,

Regard,

SACHIN

"Dave Peterson" wrote:

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

is one way.

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

Sachin Narute wrote:

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.

--

Dave Peterson

All times are GMT +1. The time now is 12:10 AM.