Sum Value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spread sheet with the following formula. =COUNTIF(B3:B34,"W") This
adds the total count. I want to add to the formula if a cell contains "s" it
would add an additional 5 to the total count. any help would be greatly
appreciated.

Richard
 
If the S is in the same range of B3:B34 then
=IF(COUNTIF(B3:B34,"S")>0,COUNTIF(B3:B34,"W")+5,COUNTIF(B3:B34,"W"))
If you wanted to add 5 for every S in the same range, then
=COUNTIF(B3:B34,"S")*5+COUNTIF(B3:B34,"W")
 
Thanks that gets me going.

Richard

JLatham said:
If the S is in the same range of B3:B34 then
=IF(COUNTIF(B3:B34,"S")>0,COUNTIF(B3:B34,"W")+5,COUNTIF(B3:B34,"W"))
If you wanted to add 5 for every S in the same range, then
=COUNTIF(B3:B34,"S")*5+COUNTIF(B3:B34,"W")
Click to expand...
 
Back
Top