summing ranges

[d0wnt0wn]

is there a formula to sum a range that may have text in some of the cells....

and in another cell but that same range if the same text occurs 3 times it returns "something"

 

[Scott Huish]

Are you wanting to count cells that have certain text in them?

And then you want to indicate if that text occurs in your range exactly three times?

Is this correct?

If not, you may want to explain this in more detail, and perhaps post a sample of your sheet with expected results. Link to Colo's HTML Maker is at the bottom of this page.

 

[d0wnt0wn]

its like this lets say i have a range in a1 to a10

1
2
4
6
7
hat
4
hat
2
4

sum a1:10.....the next time i do this.. there might not be any text or it may be in a different spot


then also if hat is in there 3 times id lke the cell a12 to return lets say "winner"

 

[Aladin Akyurek]

its like this lets say i have a range in a1 to a10

1
2
4
6
7
hat
4
hat
2
4

sum a1:10.....the next time i do this.. there might not be any text or it may be in a different spot


then also if hat is in there 3 times id lke the cell a12 to return lets say "winner"

What if the count of "hat" is above 3? Am I understanding it right that you want to see "winner" in A12 if there is 3 or more hats in A1:A10, otherwise a sum of the numbers in A1:A10?

 

[daniels012]

Here is your code in A11
=SUM(D11:D20)
Here is your code in A12
=IF(COUNTIF(D11:D20,"hat")=3,"WINNER","Less than two")

Hope this helps,
Michael