Given that you haven't taken the time to tell us what the criteria is,
nor given us the field and table names involved, what is it you would
like from us?
Well what is your problem you are having. You did not say what you di and
what the results was.
SUMIF is used in Excel. What formula are you trying to use? Post your
query SQL.