Cross sheet Formula

Lynna

What formula should I use to populate column E in "GHG Electricity" adding monthly total (Columns E to P) from cross sheet "SPI Data" for each site (in Column A) with Electricity (in Column C) ?

GHG Electricity.xlsx

SPI Data.xlsx

THANKS!!

Bassam Khalil

Hi @Lynna

Hope you are fine, I prepared sample sheets for your case you can find them in the following link and you can use the following formula and change it to a column format formula

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

1- GHG Electricity Sheet

https://app.smartsheet.com/b/publish?EQBCT=16dcacf34b264dd7aaf37b80c77852a3

2- SPI Data Sheet

https://app.smartsheet.com/b/publish?EQBCT=60bb2445cb5042b09d9f818a1e5cc5db

Bassam Khalil

Hi @Lynna

Hope you are fine, I prepared sample sheets for your case you can find them in the following link and you can use the following formula and change it to a column format formula

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

1- GHG Electricity Sheet

https://app.smartsheet.com/b/publish?EQBCT=16dcacf34b264dd7aaf37b80c77852a3

2- SPI Data Sheet

https://app.smartsheet.com/b/publish?EQBCT=60bb2445cb5042b09d9f818a1e5cc5db

Lynna

Thank you so much Bassam!! Have a great day!!!

Lynna

How do I save these files so I can click and view the "reference". I can't seem to view the reference or I am not clicking the right spot? THANKS!

Bassam Khalil

Hi @Lynna 

Happy to help you anytime, the reference is in sheet 2 ( SPI Data Sheet )

https://app.smartsheet.com/b/publish?EQBCT=60bb2445cb5042b09d9f818a1e5cc5db&_ga=2.158918073.2023477333.1611467637-1260905219.1603416350

Lynna

Yes, the reference range is in  "SPI Data sheet" but how do I look to view the reference range that was selected.  For example "SPI Data Total".  I could not click and view the range that was selected. 

Bassam Khalil

Hi @Lynna 

Hope you are fine, if you like me to do it in your sheet directly please call me on my Whatsapp ( +966530973300 ) and i will tell you what to do.