Hi Guys and Girls,

I first want to say I'm happy to be here at this nice active forum. My name is Amro and I'm the co-founder of a courierservice called Silver Sprint. We are based in the netherlands and we are doing pretty ok but I have a question about excel.

I have made a dashboard for my key performance indicators but I would like to calculate the average numbers.

Say I have this

Date Reveneu Costs etc.
1 100
2 150
3 230
4
5
6 140
etc

As you may have seen I didn't fill two days because those were the weekend.

So basically what I want to achieve is I would like to know what formulla to use to calculate the average per day but only on the days I generated revenue otherwise the stats will be polured.

Can someone help me out here?

Thanks!