Provide the average of column P when a number in A2 and a date in B2 are the same ?

[joeydeacan]

I wondering if this can even be done, Ive been pulling my hair out, Ive got 700 lines of data and have started doing this manually and im not even on three figures yet.

I have done column P manually so you can undertsand my explanation.

Any help greatly , and I mean very gratefully receievd.

 

[joeydeacan]

 

[Joe4]

Just use the AVERAGEIF function.

Put this in P2 and copy down to P7:

=AVERAGEIF($A$2:$A$7,A2,$O$2:$O$7)

 

[Fluff]

How about

+Fluff New.xlsm
	A	B												N	O	P
1
2	810	01/08/2020													9.87	9.87
3	800	03/08/2020													19.74	9.975
4	800	03/08/2020													0.21	9.975
5	805	03/08/2020													9.03	4.62
6	805	03/08/2020													0.21	4.62
7	808	03/08/2020													21.42	21.42
Master

Cell Formulas
Range	Formula
P2:P7	P2	=AVERAGEIFS(O:O,A:A,A2,B:B,B2)

 

[Joe4]

Note: I was working off the first image, which only considers column A.
Fluff's worked off the second image, which considers column A and B. So I am guessing that is the formula you want.

 

[joeydeacan]

Works fine with a small number, but is there a way of including the date ? For example I will have another set that have 800 in column A, but the date will be 04/08/2020.

So if A2 and A3 are the same AND B2 and B3 are the same, im not sure im explaining very well.

 

[Fluff]

See post#4

 

[joeydeacan]

You guys !!!!! You guys.

I love you guys, it worked, its brilliant, im shocked and in awe !!!!

If you would both like to set a charity Id like to make a small donation on your behalf as a mark of thanks

 

[Joe4]

Glad we were able to help!

If you would both like to set a charity Id like to make a small donation on your behalf as a mark of thanks

I usually tell people just to pay it forward!

If you really want to make a donation, I would just say donate to some local charity in your area that is helping those with the Pandemic, whether it be first responders, or those providing support to those who may have lost their jobs.