=SUMIF(B1:B199,"business account",D1:D199)

The formula above returns the correct total - this is displayed in another
worksheet - the sheet the formula resides in displays the formula NOT the
result.

Any ideas, anyone?

Many thanks!

Regards,

Mike

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