yogi_Compute Sum Of Amounts From Intersection Of Ranges

Google Spreadsheet   Post  #2291

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Nov-16-2017

question by: Pierre Lbchr

https://productforums.google.com/forum/?utm_medium=email&utm_source=footer#!msg/docs/pIubguc22sM/DgE4u5-DCgAJ;context-place=forum/docs

Add the intersection of two ranges ?

've a range named for each month ("June" : 2:4, "July" :6:7 & "August" : 9:11) and a range named for the price ("Price" : D:D). Is there an operator to add the values of the intersection of the range "July" and the range "Price" to obtain the total for July ?

Thank you in advance.

Pierre