Enter this in D1 with AAA or BBB in C1
=SUMPRODUCT(--(A1:A100),--(B1:B100=C1))
to get the sum
and
=SUMPRODUCT(--(B1:B100=C1))
to get the count

Change 100 to the end of your data set

to get count
--
Always provide your feedback...


"silversilver" wrote:

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?