View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Angiewelly Angiewelly is offline
external usenet poster
 
Posts: 10
Default IF with two columns

Hello, I have put the following formula in to try and add figures together
but only when a certain word in in the first column. Can anyone see my
mistake?

=IF(C3:C207="CA",(COUNTIF(I3:I207,"OG")))

I am not a bright chicken so if you can help please make it as easy if
possible.

Many Thanks