| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum Value
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sum Value
Is the 'S' in the same range of B3:B34? or in another column?
"Richardb" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sum Value
If the S is in the same range of B3:B34 then
=IF(COUNTIF(B3:B34,"S")0,COUNTIF(B3:B34,"W")+5,CO UNTIF(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") "Richardb" wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sum Value
Thanks that gets me going.
Richard "JLatham" wrote: If the S is in the same range of B3:B34 then =IF(COUNTIF(B3:B34,"S")0,COUNTIF(B3:B34,"W")+5,CO UNTIF(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") "Richardb" wrote: 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sum Value
You're welcome.
"Richardb" wrote: Thanks that gets me going. Richard "JLatham" wrote: If the S is in the same range of B3:B34 then =IF(COUNTIF(B3:B34,"S")0,COUNTIF(B3:B34,"W")+5,CO UNTIF(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") "Richardb" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
