ExcelBanter - Can I use a different worksheet for my database using DSUM?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Can I use a different worksheet for my database using DSUM? (https://www.excelbanter.com/excel-worksheet-functions/113322-can-i-use-different-worksheet-my-database-using-dsum.html)

Sandee

Can I use a different worksheet for my database using DSUM?

I'm trying to use DSUM and would like to have the result show in Worksheet 1
but use Worksheet 2 for my database, field and criteria. Unfortunately, the
result is the total field column, not just the criteria cells. Is there a
way to use a separate worksheet for the database, etc.?
--
Sandee

All times are GMT +1. The time now is 12:35 PM.