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