Thread: Sum Value
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JLatham JLatham is offline
external usenet poster
 
Posts: 3,365
Default 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