formula
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)
--
Kevin Backmann
"Rob" wrote:
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,
|