I have this data set where I am trying to calculate the area under the curve in excel ; I found an equation (C3+C4)/2*(B4-B3). I am trying to calculate the area with a baseline method where I keep one stable y-value per attached in the image below. Is there a way to do this in excel? The black line is the curve and the red line is the baseline that I want to use (not zero). Any help is appreciated!! Thanks in advance :)
