You're missing an argument in the last condition OR you need to change the last * in the formula to a comma
=IF(C2="","",SUMPRODUCT(('EQ Summary'!$C$4:$C$5000=$C2)*('EQ Summary'!$E$4:$E$5000=1),('EQ Summary'!$AL$4:$AL$5000)))
You're missing an argument in the last condition OR you need to change the last * in the formula to a comma
=IF(C2="","",SUMPRODUCT(('EQ Summary'!$C$4:$C$5000=$C2)*('EQ Summary'!$E$4:$E$5000=1),('EQ Summary'!$AL$4:$AL$5000)))
If I've been of help, please hit the star
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks