Average

[mark]

I am trying to calculate the average amount of time it
takes for payments to be processed.

In Column A I have date sent

In Column B I have date Paid

In Column C I have the formula Days360


In Column D I have the formula Average

The problem I have is in column C I have the formula
running from cell C1 to C102 when it works out the
average it counts the blanks and gives out the wrong
answer.

Any help Please

 

[Bob Phillips]

How about

=SUMPRODUCT((A17:A20<>"")*(B17:B20<>""),(B17:B20-A17:A20))/SUMPRODUCT((A17:A
20<>"")*(B17:B20<>""))

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Robert]

try
=AVERAGE(IF(C1:C120<>0,C1:C120,""))
array entered (Ctrl Shift Enter)

This would check there is a value other than zero in the Days360 cells

If you wished to average based on the payment being made simply change to
=AVERAGE(IF(B1:B120<>"",C1:C120,""))
array entered (Ctrl Shift Enter)

This would be useful if the date sent has been entered but not recieved.

One question for you. Why use Days360 and not simply =B1-A1 formated as
General?

let us know how you do.

HTH
Rob