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)
Attach File Manager is below Advanced editor window, click Go Advanced below Quick Reply window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
DEBUG! DEBUG! DEBUG!
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.