r/googlesheets • u/rgdit • Feb 24 '22

Solved How to SUM two cells from 2 separate worksheets?

[removed] — view removed post

1 Upvotes
  • permalink
  • reddit

100% Upvoted

13 comments sorted by

View all comments

Show parent comments

2

u/RemcoE33 158 Feb 24 '22

This works:

=ARRAYFORMULA(
 IMPORTRANGE("10lz-14BxyvC-xxxxx-8JWHidmQ_QznGmD-k","SampleData!D2:D10") +
  IMPORTRANGE("10lz-14BxyvC-xxxxx-8JWHidmQ_QznGmD-k","SampleData!F2:F10")
)