Sum of values in a column within quarters

Nikola_Masova

Hi All,

I need some help. I need a formula for sum of values within one column but I need to count it based on completion date. For context I want to messure how many labels were completed withing Q1, Q2, Q3 and Q4 2026. In my sheet is column with total amount of labels per change and another column has a date of completion.

I tried this formula but had no luck.:

=COUNTIFS({2025 EMEA Projects Range 4}, {2026 EMEA Projects Range 1}, >=DATE(2026, 1, 1), {2026 EMEA Projects Range 1}, <=DATE(2026, 3, 31))

Can someone see where could be the issue please?

Thanks a million for your help!

Yasar_6

Hi,

The issue is that COUNTIFS counts rows, but you said you want the sum of labels. You should use SUMIFS instead.

=SUMIFS({2025 EMEA Projects Range 4}, {2026 EMEA Projects Range 1}, >=DATE(2026,1,1), {2026 EMEA Projects Range 1}, <=DATE(2026,3,31))