Counting with 2 criteria

A

Amethyst

I need to be able to pull counts from a frequently updated list based on
associate's name and status of order.
 
J

JLatham

=SUMPRODUCT(--(A1:A100="associate name"),--(B1:B100="status"))
should do it for you, adjust the columns/rows to match your sheet.

You could have a couple of cells to enter associate name/status into to make
things easier; as associate name in C1 and status in D1:
=SUMPRODUCT(--(A1:A100=C1),--(B1:B100=D1))
 
A

Amethyst

Thanks so much! That works beautifully. Now I need to be able to add the
dollars in a column that belongs to that associate.
 
A

Amethyst

I figured out how to sum a column of $ values for a specified associate. If
it would help someone else, the formula with the name in Col A and the $
values in Col H:
=SUMPRODUCT(--(A1:A100="associate name"),--(H1:H100))
 

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

Trying to create custom labels from an csv file + Need items numerically counted out 0
'Data Type Mismatch In Criteria Expression' error when using 'Count' in query Design; Help! 0
Summing Results Based On A Specific Date 2
Count Number of Unique Cells That Don't Have Certain Characters 0
Remove Identical words 0
Counting # of entries for each month, in a specific status 3
Using <= in countifs statement 1
Extracting data/using COUNTIFS 2

Top