Average & Sum using Count If excluding Blank Cells

[ravi2628]

Dear Friends,

I was using a Formula where i need to exclude blank cells at average or sum in the given range criteria.

Due to IT Restriction Macro or addons can not work out to get the raw data

Due to Current formula count i was getting is 464
Current Formula :=ROUNDUP(AVERAGE(COUNTIFS('20-Jan-25 to 03-Mar-25'!$AD:$AD,E$25:G$29,'20-Jan-25 to 03-Mar-25'!$D:$D,Summary!$A8)),0)

Between e25:G29 empty cells has to be excluded while calculation

But actual Count is 696

Please help me out with the formula

Snap shot for ref:

 

[alansidman]

Please read post #7 and show us what you want. I don't think we understand what you are asking for obviously as you keep indicating that we are not getting what you want.

 

[Alex Blakenburg]

I am also unclear as to what you want, so here is another guess:
(in your example you say 18 but that is for a single day and you are saying you want a range of dates The below does not count lines with nothing in column A)

Book1
	D	E	F	G
1		Filtered Date(Column)		Average of Daily Count
2	From	20/01/2025		13.6
3
4
5	To	24/01/2025
Sheet1

Cell Formulas
Range	Formula
G2	G2	=LET(uniqDates,UNIQUE(FILTER(B2:B69,(B2:B69>=E2)*(B2:B69<=E5))), dailyCount,BYROW(uniqDates,LAMBDA(uD,SUM(--(B2:B69=uD)*(A2:A69<>"")))), AVERAGE(dailyCount))