Easy One!
 

I have this formula:

=COUNTIF(A1:A10,"sup")

I want the sum of a few other acronyms as well. How can I retrieve the sum
of several different acronyms within the same data range? Help!!!

Easy One!
 

Never mind. I got it =COUNTA(A1:A10)

"Skydiver" wrote:

I have this formula:

=COUNTIF(A1:A10,"sup")

I want the sum of a few other acronyms as well. How can I retrieve the sum
of several different acronyms within the same data range? Help!!!

Easy One!
 

=COUNTIF(A1:A10,"sup")+COUNTIF(A1:A10,"pus")
Would enable you to count specific entries
Counta only tells you if there is an entry in a range i.e. non blank cells
--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"Skydiver" wrote:

I have this formula:

=COUNTIF(A1:A10,"sup")

I want the sum of a few other acronyms as well. How can I retrieve the sum
of several different acronyms within the same data range? Help!!!

Easy One!
 

=COUNTIF(A1:A10,"sup")+=COUNTIF(A1:A10,"dude")

Skydiver wrote:
I have this formula:

=COUNTIF(A1:A10,"sup")

I want the sum of a few other acronyms as well. How can I retrieve the sum
of several different acronyms within the same data range? Help!!!

Easy One!
 

You're right Russell! Thanks for posting! I wanted specific entries after
all. You guys are awesome!!!

"Russell Dawson" wrote:

=COUNTIF(A1:A10,"sup")+COUNTIF(A1:A10,"pus")
Would enable you to count specific entries
Counta only tells you if there is an entry in a range i.e. non blank cells
--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"Skydiver" wrote:

I have this formula:

=COUNTIF(A1:A10,"sup")

I want the sum of a few other acronyms as well. How can I retrieve the sum
of several different acronyms within the same data range? Help!!!