Count Based on Comparison with Two Fields


M

Mashuganah

I recently learned that I can count the number of items in one column that
match items in another column by using:

=COUNT(MATCH( 'Sheet1'!G2:G15001, 'Sheet2'!A2:A15, 0))

However, I now need to count records on one sheet in which TWO fields match
items in both of two separate columns (i.e., a comparison of two columns to
two columns and a count of records in the first that have fields matching
elements in the second) .

My attempt to use the above statement with an AND failed. Can someone
explain how to do this?
 
Ad

Advertisements

F

Francis

Hi

I would suggest that you post a before and after example. This will help us
to
help you.
--
Hope this help

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis
 
Ad

Advertisements

M

Mashuganah

I want to read each row in my data list , compare the "Caller" field to the
VIP List and compare the "Support" field to the "Support Personnel" list.
For records on the data list where the Caller matches someone on the VIP list
AND the content of the Support field matches someone on the Support Personnel
list I want to add one to the counter.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top