Sum number of letters between two dates

[olivergs1982]

Hello everyone, long time user of the forum, irregular poster as I can almost always find what I want though can't for some reason with this one.

I need to sum how many numbers or letters that are between two variable dates on a calendar. Dates are on row 3
AG3:ON3 have my dates from 01/10/20, 02/10/20, etc. to the end of the calendar.
Row 14 has an "h" which correspond to each date above that needa the "h" in, the rest are blank.
I need to sum how many "h" there are between a variable start and end date.
G14 has start date of 07/10/20, F14 has end date of 31/01/20, though as stated, both are variable.

Thanks all

 

[AlanY]

assuming F14 is the start date and G14 is the end date

=COUNTIFS(AG14:ON14,"h",AG3:ON3,">="&F14,AG3:ON3,"<="&G14)

 

[etaf]

COUNTIFS()
=COUNTIFS($AG$14:$ON$14,"H",$AG$3:$ON$3,">="&$F$14,$AG$3:$ON$3,"<="&$G$14)

Example in different Rows/Columns, just so you can see it in operation

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	1/1/20	1/2/20	1/3/20	1/4/20	1/5/20	1/6/20	1/7/20	1/8/20	1/9/20	1/10/20
2	H			H	H	H	H	H	H	H			1/3/20	1/6/20	3
Sheet1

Cell Formulas
Range	Formula
O2	O2	=COUNTIFS(A1:J1,">="&M2,A1:J1,"<="&N2,A2:J2,"H")

 

[olivergs1982]

Can't get it to work for me Uploadded a redacted view of the sheet. I need AF10 to give me the total od all cells with letter H, from everything after 27/09/20 to 31/10/20.

 

[etaf]

what formula have you used in AF10

 

[etaf]

IGNORE _ different user as SPAM

 

[olivergs1982]

I actually think I've manged to get it to work. I'm using a google sheet as well as excel (don't ask me why, just my weird way of working) and when I basically started from scratch and put everything back into it, it works! Thank you so very much for your help!

 

[etaf]

glad you managed to resolve the formula and get it working