lookup text in one column, count in another column
 

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!!!

lookup text in one column, count in another column
 

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


"dmshurley" wrote:

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!!!