calculating the number of days

**Deanomcbeano** · 10-02-2012, 03:52 AM

Hi Winon

Thank you for the response. I was hoping to calculate the results per week, i.e. total runs for week 38, total for week 39, rather than cumulatively. I've included an example sheet with the data as it should work out - but without the formulas. Would you be able to take a look?

Regards
Dean

**Fotis1991** · 10-02-2012, 04:18 AM

Hi

... I was hoping to calculate the results per week

In this case(as you use Excel 2003), SUMPRODUCT, maybe works for you.

Unfortunatelly the results are not the same as these that you put manually to your examle.

Do you mind to take a look to my sheet example?

**Deanomcbeano** · 10-02-2012, 04:36 AM

Hi Fotis

Thanks for the assistance. The columns K and N are calculating correctly, and I can use that formula. However columns I, J, L and M are not right - the totals should be cumulatively increasing for columns I and L. Whilst for columns J and M the days between each run should only be in single figures as in my example.

Any further suggestions?

Cheers
Dean