Sumproduct to directly get the total count for each quarter & year

[chaiyya345]

Hi All,
I have used SUMPRODUCT with Quarter column D103:D106 & Year (column C103:C106) criteria it works perfectly fine. However, when I get Quarter count directly from the column C103:C10 I get the incorrect count.

Please Login or Register  to view this content.

How to achieve this?

Your help is very much appreciated. Please find attachment.

Thank-You very much

[Bo_Ry]

Please try at K3

=SUMPRODUCT((ROUNDUP(MONTH($C$3:$C$106)/3,0)=ROWS(K$3:K3))*(YEAR($C$3:$C$106)=K$2))

[bebo021999]

Try to combine "Q" then create logical_statement:

Please Login or Register  to view this content.

[chaiyya345]

Hi Bo_Ry,
Thanks..it fixed. the incorrect count ive gotten from was without ROW.

Hi bebo021999,
Thanks. your solution fixed too..

Issued you both reputation.

I will mark this thread to Solved.

Thank-You very much