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? Monthly EarningsJanuaryFebruaryMarchGross Revenue 160017001800Operating Cost 488520790EBITDA 10591080790EBIT 536560260Net Profit 169140180

GrishmaChokshi =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.

Forum Discussion

GrishmaChokshi

Copper Contributor

Aug 22, 2022

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?

Monthly Earnings	January	February	March
Gross Revenue	1600	1700	1800
Operating Cost	488	520	790
EBITDA	1059	1080	790
EBIT	536	560	260
Net Profit	169	140	180

excel

1 Reply

OliverScheurich
Gold Contributor
Aug 22, 2022
GrishmaChokshi
=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.