View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John John is offline
external usenet poster
 
Posts: 2,069
Default Count IF Formula

Hi All,

I have a problem below. I need to count if the value in column C equal to
value in column A then count column B. In this case "AGB" should be "2" and
"HHH" should be "3".

Column A Column B Column C
HHH 10 AGB
AGB 10 HHH
HHH 10 NNN
HHH 10 MMM
AGB 10 BBB
. . .
. . .
. . .

Thank you
John