Thread: SUMIF and IF
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
silversilver silversilver is offline
external usenet poster
 
Posts: 1
Default SUMIF and IF

I have two columns, one of text and one of numbers.

I'm trying to get a sum of the cells in column A if column B has a
particular text.

For Instance:

1 AAA
2 BBB
1 CCC
3 AAA

I need a formula that counts the value of the cells in column A when column
B says AAA.

Any suggestions?