Forum Discussion
GrishmaChokshi
Aug 22, 2022Copper Contributor
VLOOKUP
Hi - I'm trying to use lookup formula to calculate the look-up value from multiple sheets (basically the sum of those values), but it's not working. Is there another formula I should use instead? ...
OliverScheurich
Aug 22, 2022Gold Contributor
=SUMPRODUCT(($B$1:$D$1=B11)*$B$2:$D$6)In order to sum values you can try SUMPRODUCT. The formula can be applied across several sheets as well.