Maybe

=(SUM(G24:G91)-G87)/(SUM(F24:F91)-F87)

--
Regards,

Peo Sjoblom

Portland, Oregon




"Chris Cred via OfficeKB.com" <u17747@uwe wrote in message
news:5a9e9b49b12c8@uwe...
Dave-

The statement does have all three factors(logical, true, and false) and
also
returns a value, however, it is not the correct value.

Anyway, here is what I'm trying to accomplish...

Take the sum of (G24:G91) and subtract G87 and G90, take the sum of
(F24:F91)
and subtract F87 and F90, then divide the final result of G by the final
result of Ffor my value.

Here's what I switched my formula to...However, it will only calculate the
first portion and not divide by F.
=SUM(G24:G91)-(G87)/SUM(F24:F91)-(F87)

Dave O wrote:
This part:
SUM(G24:G91-G87:G90)
... should look like SUM(G24:G91)-SUM(G87:G90)

Also, recall that the first part of an IF statement is a logical test-
so the formula needs to say "If sum(this, that, the other) is equal to
that, return a value if the logical test is true, return another value
if the logical test is false". Your IF does not appear to contain that
logical test.

--
Message posted via http://www.officekb.com