ExcelBanter - Sum Value

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Sum Value (https://www.excelbanter.com/excel-discussion-misc-queries/157637-sum-value.html)

Richardb

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

JLatham

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

JLatham

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

Richardb

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

JLatham

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

All times are GMT +1. The time now is 07:20 AM.