IF with two columns

A

Angiewelly

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
 
D

David Biddulph

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")) ?
 
A

Angiewelly

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)
 
D

David Biddulph

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subtracting two cell dates and highlight if over due by a certain amount of days 0
Sum of two highest numbers 7
Search for string based on two columns 2
Help with Sumproduct searching cell contents 2
possible countif formula? 3
series of formulas to get to one formula 0
Multiple IF statment help 7
How to put this data sorted by character in each cell 1

Top