Excell devision formula

D

Dizzy Des

I want to find the average spend per customer starting with a cell containing
a sum of money & devide-ing that sum by the number of customers.
Typically 5000 devided by 25 = 200
 
F

Frank Kabel

Hi
you may provide some more details HOW your data is currently structured
(e.g. post some example data rows in plain text - no attachments
please)
 
P

Peo Sjoblom

=SUM(Range)/COUNTA(Customer_Range)

or hard coded

=SUM(Range)/25

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Top