BrutalLogiC
Board Regular
 Joined
 Feb 26, 2006
 Messages
 247
 Office Version

 2016
 Platform

 Windows
=SUMPRODUCT((YEAR($D$24:$AN$24)=H2)*($D$25:$AN$36))
trying to adjust above so the full formula is returning the value based on:
1. the year in D24:AN24 being equal to H2; and
2. the criteria in B25:B35 being equal to E3
with the values in the range D25:AN36
help!
trying to adjust above so the full formula is returning the value based on:
1. the year in D24:AN24 being equal to H2; and
2. the criteria in B25:B35 being equal to E3
with the values in the range D25:AN36
help!
Last edited: