Excel Query

D

dave230

I have a worksheet and I would like to query and count the number of records
by looking at 2 different colums and picking those records which contain the
required data in both.
 
S

Sheeloo

=SUMPRODUCT(--(A1:A100="Something in Col A"),--(B1:B100="Something in B"))

Change 100 to last row in your data set and conditions to what you want or a
cell reference.
 

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

Similar Threads

Access Dcount (multiple criteria) 3
Access Access Query Criterion 1
Excel Query setup 0
Counting multiple memberships 1
Sum and count of unique values 4
Count dublicates 2
Lookups 6
Parameter Query 4

Top