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

IF with two columns
 

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 Biddulph

"Angiewelly" wrote in message
...
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

IF with two columns
 

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)

"David Biddulph" wrote:

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 Biddulph

"Angiewelly" wrote in message
...
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

IF with two columns
 

Glad it helped.
--
David Biddulph

"Angiewelly" wrote in message
...
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)

"David Biddulph" wrote:

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

"Angiewelly" wrote in message
...
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

IF with two columns
 

is it possible to use wildcards?


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
Glad it helped.
--
David Biddulph

"Angiewelly" wrote in message
...
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)

"David Biddulph" wrote:

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

"Angiewelly" wrote in message
...
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

IF with two columns
 

Where?

What are you trying to do?

Care to elaborate?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Sulasno" wrote in message
...
is it possible to use wildcards?


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
Glad it helped.
--
David Biddulph

"Angiewelly" wrote in message
...
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)

"David Biddulph" wrote:

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

"Angiewelly" wrote in message
...
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