average

[puiuluipui]

Hi, i have something like this:
Only 6 days have entries in this ex.

day 1 = 1200 km
day 2 = 1245 km
day 3 = 1300 km
day 4 = 1315 km
day 5 =
day 6 = 1350 km
day 7 =
.....
day 30 = 1500

A38 = 300km (km/month)
I need 300/nr of days = 50km/day
In this example i have only 6 entries with km. But in other days i can have
more or less days with km.

I need a formula to calculate how many days have km (EX:6), and to divide
the result in A38 to the number of entries found in A1-A37.
Can this be done?
Thanks!

 

[Clarity]

Hi,

You should be able to use the COUNT or COUNTA formula.

However if these do not work because of your data layout you could try using
a "helper" column containing the formula:

Assuming day data is in Col A and km data is in Col B and cell is blank if
no KM:
=if(B1="",0,1)

This will then give you a column of zeros that you can sum as your total
number of days with km.

Myles