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