AutoIanCopper ContributorJan 10, 2022Calculating cell based on row data 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 A B C D 1 January July 2 Febuary August ...Show More
mtarlerSilver ContributorJan 10, 2022AutoIan the formula is=COUNTIFS($C$10:$C$18,LEFT(A1,3))see attachedcountifs-example.xlsx10 KB