IF with two columns

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

Guest

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
 
You haven't said whether or not you entered that as an array formula, but in
either case I don't think that it'll work
Why not try =SUMPRODUCT((C3:C207="CA")*(I3:I207="OG")) ?
 
David,

It worked. You are a genius! You have just saved me hours of work. Thank you
very much.

Angie (the not very bright chicken)
 
Glad it helped.
--
David Biddulph

Angiewelly said:
David,

It worked. You are a genius! You have just saved me hours of work. Thank
you
very much.

Angie (the not very bright chicken)
Click to expand...
 
Back
Top