How to write formula to add few columns in a row from selected rows

Lynna

How to write formula in another sheet referencing this sheet to add few columns in a row for selected rows ? for example, sum all electricity for all sites e.g. Aizu, Belgium, Bucheon...etc for Q1 (Jan, Feb and Mar). THANKS!

SPI Data.PNG

SPI Data.xlsx

Bassam Khalil

Hi @Lynna

Hope you are fine, i solved this issue for you in my previous post, please recheck Cross sheet Formula.

=SUMIFS({SPI Data Total}, {SPI Data Site}, Site@row, {SPI Data Parameter}, Parameters@row)