lookup text in one column, count in another column

G

Guest

I want to look up "DSC" in column BH, then I want to count different values
in column AC, but I only want to count the occurences of value in column AC,
if "DSC" occurs in column BH.

I tried =if(vlookup(bh8:bh550,"dsc),(countif(AC8:AC650,"X"))

I've tried everything at this point.

If BH8:BH550 is "DSC", then count AC8:AC550,"X"

There are different values in both columns and I need a formula to perform
this function based on the "DSC" and "X" criteria, which may change to
something like "KLK" and "S".

HELP!!!
 
G

Guest

Try using SUMPRODUCT:

=SUMPRODUCT(--(BH8:BH550="DSC"),--(AC8:AC550="X"))

You could also replace "DSC" and "X" with cell references, like:

=SUMPRODUCT(--(BH8:BH550=A1),--(AC8:AC550=B1))

Then type in the values you wish to match in cells A1 and B1

HTH,
Elkar
 

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

Deleting Code from a Worksheet is Locking Up 5
Excel How to count from a column if specific condition in another column is true 3
counting values in a column 7
Count values in one column only if criteria is met in the next column. 0
Counting occurences with multiple entries 5
Count the columns from one sheet and paste it in another sheet 0
Count Unique Values in 1 Column based on Date Range in another Column 28
Formatting dollar values in text 9

Top