Rod has attended:
Excel Advanced course
SUMPRODUCT WITH OR function
Hi,
Can you advise how I amend the formula below so that the calculation performs if C3:C1000 is either "Brent" or "Gasoil".
=SUMPRODUCT(($C3:$C1000="Brent")*($E3:$E1000="16/17")*H3:H1000,$T3:$T1000)
RE: SUMPRODUCT WITH OR function
Hi Rod,
Thank you for the forum question.
Try:
=SUMPRODUCT((($C3:$C1000="Brent")+($c3:$C1000="Gasoil"))*($E3:$E1000="16/17")*H3:H1000,$T3:$T1000)
Please ley me know if this work.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector