average
 

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!

average
 

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


"puiuluipui" wrote:

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!