Calculating cell based on row data

Occasional Contributor

Hi,

I have this table below, I need to be able to show the number next observations due for each month (C10:C18)

 

Thanks Ian

 ABCD
1January July  
2Febuary August 
3March September 
4April October 
5May November 
6June December 
7    
8    
9Month Last Observedcurrent GradeNext Observation Due 
1020-Apr-21GreenOct 
1127-Apr-21GreenOct 
1221-Jul-21GreenJan 
1315-Jul-21GreenJan 
1419-Oct-21GreenApr 
1527-Jul-21GreenJan 
1611-May-21GreenNov 
1718-May-21GreenNov 
1813-Jul-21GreenJan 

 

1 Reply

@AutoIan the formula is

=COUNTIFS($C$10:$C$18,LEFT(A1,3))

see attached