Forum Discussion
Solved
How to analyze excel data
The above attached data in excel sheet is a snap from my experiment. There are four columns with header . There are total 280 trials in total (40 times each of 50,100,150,200,250,300,350 ...
=SUMPRODUCT(($C$2:$C$281=$F2)*($D$2:$D$281=G$1))Alternatives could be SUMPRODUCT or Power Query.