Conditional formulas

Hey,

Not sure if the title for this thread is correct, I am not familiar with the meanings of excel jargon.

But what I am looking to do is calculate values across criteria. So I have a certain amount of test subjects, and each test subject has multiple values ('cases'?) across a certain time period (value calculated each second). I want to calculate the average across each time section, based on the condition. So all conditions '1', I want them to be averaged all together along time 1, time 2, time 3 and so on (averaged across all test subjects). This way I will be able to construct 4 lines (in a graph) in total (there are 4 conditions) that progress along a certain time length (17 seconds in the illustration). I think this is not a difficult thing to do in excel, but I just dont know how to do it.

Hi, welcome to the forum

See if this is what you want? I made a small table with 1-4 going down, and seconds across the top. I only show 4 seconds, but you just need to copy across for the others...

	T	U	V	W	X
2		1	2	3	4
3	1	75.10245	77.62356	78.67491	79.83947
4	2	72.31643	74.55133	75.82663	79.02106
5	3	76.90889	77.00493	79.1175	82.64388
6	4	73.6959	75.31468	76.24143	78.3176

U3=AVERAGEIFS(C:C,$B:$B,$T3)
copied across and down as needed

Happy to help
If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below my 1st post to you)