formula

  • Thread starter Thread starter Rob
  • Start date Start date
R

Rob

I have a spread sheet where I want to divide two columns. The information in
the columns doesn't have anything to do with the division i just need it to
recognize it has an input.

column a tournament amount column b is amount won. I want to have the
percentage of tournaments won excel recognzing that something is inputed. So
column b would be divided by column a, what's in the column cant matter only
if something is in there at all.

Hope that's not too confusing,
 
Assuming that you're entering tournament amounts i A1 through A500 and the
amount won in B1 through B500, the following formula would give you the
percentage of the amount won:

=SUM(B1:B500)/SUM(A1:A500)
 

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

absolute ranges 3
A different kind of VLookup 8
Running Total 3
Trying to do too much? 5
Line graph colors 5
Numeric input in E to divide by 2 automatically in H 3
Formula Question 2
Desperately Need Excel Formula Help! 3

Back
Top