Accounts functions
sorry should also have noted that the results need to be displayed on a
seperate worksheet, as the imported data will be held in a hidden worksheet
"Joel" wrote:
the criteria can be any boolean operation including a AND function
=sumfi(A1:a100,and(criteria1,criteria2,criteria3), B1:b100)
"philn" wrote:
Hi I have imported data (nominal ledger transactions) from Sage 50 and need
to query the results to total transactions for a particular nominal ledger
code that fall between given dates.
I have attempted to use sumif, but find i can only place 1 criteriea on it
and sumproduct seems to dislike the date range
|