Forum Discussion
Ankit27
May 15, 2022Copper Contributor
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 millisecond stimulus duration). I want to see for 50 ms duration (which is total 40 in number), how many number of '1' response button was pressed and how many number of '2' response button was pressed? Similarly for all other duration (100,150,200,250,300,and 350 ms), I want to analyze the same thing.
Please help me out with this problem. I am not expert in Excel. Thanks in Advance. If you want me to upload or share excel sheet with you, I will share with you.
- OliverScheurichGold Contributor
=SUMPRODUCT(($C$2:$C$281=$F2)*($D$2:$D$281=G$1))
Alternatives could be SUMPRODUCT or Power Query.
- PeterBartholomew1Silver Contributor
Or the same formula 'simplified' through the use of defined names and dynamic arrays (as opposed to direct references using mixed absolute/relative notation and copy/fills.
- Ankit27Copper ContributorThanks a lot Peter
- Riny_van_EekelenPlatinum Contributor
- Ankit27Copper ContributorThis is great .
- OliverScheurichGold Contributor
- Ankit27Copper ContributorThanks a lot Quaruple.