SUMPRODUCT - If column 'X' Does not contain

[Badvgood]

=SUMPRODUCT(('Service New Report'!A1:A3000=3)*('Service New Report'!D1:D3000="L")*('Service New Report'!E1:E3000))

I need to add to this formula another argument - If column 'X' does not contain 97 then return the result in E1:E3000

How?

Regards BVG

[Carim]

Hi,

Just insert ...

Please Login or Register  to view this content.