I have the following SUMPRODUCT formula
=SUMPRODUCT(--(INDIRECT("Data_History!A2:A311")='Graph Data'!F$4),--(INDIRECT("Data_History!B2:B311")='Graph Data'!F$5),--(INDIRECT("Data_History!C2:C311")='Graph Data'!$D$4),--(INDIRECT("Data_History!D2:D311")='Graph Data'!$E14),INDIRECT("Data_History!F2:F311"))
i want to amend the formula to say that --(INDIRECT("Data_History!D2:D311")='Graph Data'!$E14) could equal 'Graph Data'!$E14 or 'Graph Data'!$F14
Is this possible without having to repeat the formula and add together?
Bookmarks