Simplification of SUMPRODUCT formula

Hi all

Just had to make another amendment to my project ending up with the following SUMPRODUCT formula:

Please Login or Register  to view this content.

However whilst this works, I have the feeling that it is over complicated and there may be a simpler solution.

Essentially, the aim is to sum the total values in Input1!$E$2:$E$1300 where the date matches B$2 and the value in Input1!$D$2:$D$1300="CL" except
where the value in Input1!$L$2:$L$1300="T/T".

TIA ...spellbound

Your current formula sums where D = "CL" and then subtracts those where L = "T/T" regardless of whether or not D = "CL" where L = "T/T"...

If you mean to sum where D = "CL" AND L <> "T/T" then perhaps:

Please Login or Register  to view this content.