title: Sum merged cells in Google Sheets
body: <p>Okay so i'm making a pretty basic shopping list for one of my hobby projects, and i wanted to make it look a bit fancier, hence this.</p>
  
  <p>But i can't seem to figure out how to work with merged cells. If you look at <a href="https://i.stack.imgur.com/PIVCe.png" rel="nofollow noreferrer">this image</a>, this is what i'm trying to do: 
  <strong>The first red cell should be multiplied with the first blue cell, the second red cell multiplied with the second blue cell and so on and on. All of that should then be added up and displayed in the green cell.</strong></p>
  
  <p>P.S, please ignore the € signs everywhere! The cells should be treated as regular plain numbers as i'm using file formatting to make those € signs.</p>