IF with two columns

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Angiewelly - 23 Oct 2007 11:40 GMT

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

Reply to this Message

David Biddulph - 23 Oct 2007 12:36 GMT

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

Signature

David Biddulph

> 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
[quoted text clipped - 6 lines]
>
> Many Thanks

Reply to this Message

Angiewelly - 23 Oct 2007 13:28 GMT

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)

> 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
[quoted text clipped - 9 lines]
> >
> > Many Thanks

Reply to this Message

David Biddulph - 23 Oct 2007 14:55 GMT

Glad it helped.

Signature

David Biddulph

> David,
>
[quoted text clipped - 3 lines]
>
> Angie (the not very bright chicken)

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

>> > Hello, I have put the following formula in to try and add figures
>> > together
[quoted text clipped - 7 lines]
>> >
>> > Many Thanks

Reply to this Message

Sulasno - 28 Oct 2007 16:52 GMT

is it possible to use wildcards?

> Glad it helped.
>> David,
[quoted text clipped - 21 lines]
>>> >
>>> > Many Thanks

Reply to this Message

Ragdyer - 28 Oct 2007 17:58 GMT

Where?

What are you trying to do?

Care to elaborate?

Signature

Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

> is it possible to use wildcards?
>
[quoted text clipped - 23 lines]
> >>> >
> >>> > Many Thanks

Reply to this Message