Excell devision formula

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
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Functions 2
Average of column with changing numbers of records 5
What function to calculate interest on savings 2
Help Please 4
Formulas for dividing in Excell 2
Excel formula, sum the value cell and if empty cell left blank 0
formula help 2
Excel How to add numbers in same cell? 2

Top