Count Days With Entries By Month

[Marklarbear]

Hi knowledge base

I have a spreadsheet where volumes of activities are recorded by day of month. What I want to do is to summarise by month.

I have formulas in column G that sum the volumes (this formula works perfectly): ie G2: =SUMIFS($D$2:$D$400,$C$2:$C$400,">="&$F2,$C$2:$C$400,"<="&EOMONTH($F2,0))

What I want is a formula in column H that calculates the number of days in the month that has a numeric value ? ('0' is a value in this case). So for September the answer would be 29 (23/09/2023 is the only date that has no numeric value). October is currently 10 as there's no data post 11/10/2023 (and 09/10/2023 has no numeric value).

Your assistance is greatly appreciated...

 

[Phuoc]

Try this:

=COUNTIFS($D$2:$D$400,"<>",$C$2:$C$400,">="&$F2,$C$2:$C$400,"<="&EOMONTH($F2,0))

 

[Marklarbear]

works brilliantly - cheers!