I have need of to do the following:
Example:
W = 1
W = 1
W = 1
W = 1
TOT=4
where on earth W is the cell content and TOT is the sum of W.
W stands for win and is the memo within the cell. Its effectiveness equals 1. How do I create a formula to make available respectively W a plus of 1 and sum the total of adjectives?
Answers: ok... your prob is so simple... follow this:
let voice your cell b1 to b5 contains missive W... and cell b6 will be the total of cell b1 to b5...
underneath cell b6 put this formula: =COUNTIF(B1:B5,"W")
b6 will automatically display 5 for it counts W as good point of 1...
never put WW contained by one cell for it will not be valued as 1...
hope this help!
pls choose the best answer when resolve...
appreciation!!
use the COUNTIF function
example:
=countif(a1:a4, "w")
The worth would be 2 if A1 through A4 are the following:
w
l
ww
w