how to get an average for a certain letter

[streamer1234]

please help, I've tried to figure out the formula that will give me an average of letter "M" ( which will double up for letter "R" ) everything I've tired has not worked.
i have an average for both letters now which im trying to separate it to see the average per letter ( per month ).

the columns they are in are F and G. ( for the number side F2:f158 is how many days it took to deliver a product, column G2:G158 is the letter section "R and M"

how do i get the average day of deliveries for both letters per month ?

thanks A

 

[StephenCrump]

A bit of a guess, based on your description, rather than the two pictures:

	F	G	H	I	J
1	No of days	Type
2	3	R			Average
3	5	M		R	5.3
4	3	M		M	4.9
5	2	M		All	5.1
6	6	R
7	5	R
8	7	M
9	8	R
10	8	M
11	8	M
12	6	R
13	5	R
14	6	R
15	3	R
16	1	M
17
Sheet1

Cell Formulas
Range	Formula
J3:J4	J3	=AVERAGEIFS(F$2:F$16,G$2:G$16,I3)
J5	J5	=AVERAGE(F2:F16)

 

[Peter_SSs]

the columns they are in are F and G. ( for the number side F2:f158 is how many days it took to deliver a product, column G2:G158 is the letter section "R and M"

That does not mention dates or months so how are we to know what is in what month?
If the previous suggestion has not solved your problem then perhaps you could use XL2BB to give us some smallish sample dummy data and the expected results manually filled in, and explain again in relation to that sample data?
(If you have trouble with XL2BB, review the "XL2BB Icons greyed out" link in the 'Known XL2BB issues' section near the top of the XL2BB Instructions page linked above.)