How can I do SUMIF AND OR

[Gazzr]

Hi There,

Can anyone help me put the below into a formula?

What I want to do is:

If ColA = "LN" and Col B = "75" OR "76" OR "712" then SUM ColC

Thanks all.
Garry

 

[Ragdyer]

Try this:

=SUMPRODUCT((A1:A100="LN")*(B1:B100={75,76,712})*C1:C100)

 

[Gazzr]

Hi Ragdyer,

It worked perfectly!

Regards
Garry

 

[RagDyeR]

Appreciate the feed-back.
--

Regards,

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

message
Hi Ragdyer,

It worked perfectly!

Regards
Garry