Excell devision formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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)
 
=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)
 
Back
Top