Average Calculation Question

**silversprint** · 01-23-2011, 09:59 AM

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!

**DonkeyOte** · 01-23-2011, 10:12 AM

the AVERAGE function will ignore blanks/text etc

**silversprint** · 01-23-2011, 10:26 AM

Can you please explain me what to do since I'm quit new to excell?

**arthurbr** · 01-23-2011, 12:50 PM

Hi
you can find all necessary explanation in XL's help ( can be called with the F1 key)

**DonkeyOte** · 01-23-2011, 03:18 PM

Also please note if you cross post the same question on multiple message boards (eg MrExcel) you are required to disclose all relevant links per Forum Rules

Read this to understand why we ask you to do this