Re: SUMIF or Sum(IF(( neither working
AFAIK, IIf() is not available in Excel. But maybe 2002 was different. SumIf should be available in 2002.
Use SumIf when you want to use a range as criteria. If() cannot handle that.
=SUMIF('C:\Bobs Business\[Invoicing.xls]Invoicing'!C2:C199, "D E P O S I T", 'C:\Bobs Business\[Invoicing.xls]Invoicing'!G2:G199)
To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression. Attachment Manager is below Advanced editor window, click Go Advanced below Quick Reply window.