This one worked perfectly Thanks!!

"smw226 via OfficeKB.com" wrote:

Hi Nero,

The formula is called SUMIF so:

=SUMIF(N3:N13,"=x",F3:F13)

Thanks,

Simon

neroamdrid wrote:
Hello again,

Thanks for your example...I translated the formula you had into this for my
table:

=SUM(IF(N3:N13="x",F3:F13,0))

I'm getting #value! as an error...

When I go into Evaluate Formula I see this

SUM(IF(#VALUE!="x",F3:F13,0))

I've rechecked and can't isolate the issue since there are dollar values in
that field. Does it matter what type of formatting I've given to the N column
i.e. number, currency, special?

Thanks again.

I've put an example spreadsheet @ http://www.galimi.com/Examples/paid.xls
The formula to calculate paid versus unpaid is a simple formulaic array.
[quoted text clipped - 26 lines]

Thanks in advance.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200610/1