Excel Help

[Adam]

Not sure if this is a COUNTIF formula and I cant see to find the answer... maybe just one of those days!

Basically, I want to count the number of occurrences within a range of more than one specific text string.

So for example, if I had a range of data in A1:A50 and in that range the cells had different text strings i.e Yes, No, Maybe... I want to be able to return the count of multiple values... so how many times does "Yes and Maybe" show in that range.

Hope that makes sense.

Cheers
Adam

 

[Budgie]

I'd use a pivot table for that..

 

[Adam]

Don't really want to bog my sheet down with a pivot table tbh... would be better with a formula if possible

 

[Nigel]

You could do 2 separate cells with countif. One for the "Yes", one for the "Maybe". Then create a 3rd cell to add the two together?

 

[Adam]

Yeah I could, but the meaning of "Yes" and "Maybe" count towards the same total (I know not the best descriptions)... my actual data is for "Migrated", "Primary Migrated", "Back-Up Migrated"... I want all of those text strings to add up together, in 1 cell.

 

[milez89]

=(COUNTIF(A1:A50,"Yes"))+(COUNTIF(A1:A50,"Maybe"))

 

[The Boosh!]

=(COUNTIF(A1:A50,"Yes"))+(COUNTIF(A1:A50,"Maybe"))

This is how I would do it.

 

[Adam]

Awesome... works a treat

Cheers