How to calculate number of months without using helper column

[Shayeebur]

How to calculate number of months without using helper column.

 

[NARAYANK991]

Hi Shayeebur ,

Check your file now.

Narayan

 

[GFC]

It also works with:
=SUMPRODUCT((MONTH($C$7:$C$81)=(ROW(D7)-ROW($D$6)))*1;POWER($C$7:$C$81;0))

 

[Somendra Misra]

Another option:

=SUMPRODUCT(--(MONTH($C$7:$C$81)=MATCH(G7,$G$7:$G$18,0)))

Regards!

 

[Faseeh]

Yet another option:

=SUMPRODUCT((TEXT($C$7:$C$81,"MMM")=G7)*1)