View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gazzr
 
Posts: n/a
Default How can I do SUMIF AND OR


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


--
Gazzr
------------------------------------------------------------------------
Gazzr's Profile: http://www.excelforum.com/member.php...o&userid=31075
View this thread: http://www.excelforum.com/showthread...hreadid=557168