Conditional counting?

[excelnot]

Hello. I bet this is an easy one for the pros...

I have a long column that has either an A or B in the column. I want to write a function that says "check the column, find the A's, take note, and count the total number of A's". Same for the B's. Is this an IF/THEN thing? I can't get it working at all.

Thanks.

Matt

[VBA Noob]

Try

=COUNTIF(A:A,"A")

or

=COUNTIF(A:B,"A")

VBA Noob

[shg]

=countif(A1:A100, "A")

I know you can sort out the second formula ...

[excelnot]

Thanks...worked as expected!

[NBVC]

could this be used for adding up the values of another column?

for example substitute "A" for "Paid" which sits in a column next to a value... it is the value i want totaling but only if it has been paid

Use Sumif() for that:

e.g. =Sumif(A:A,"Paid",B:B) will sum B where A has "Paid" in it.