Hey everyone,
I've been stuck on this problem for a while today. I'm trying to use DSUM to give me totals in a database. The problem seems to be that the DSUM function needs to have the database columns in one continuous block; that is, you cant compose a database from different ranges. Is this true?
To explain, I've attached an example.
What I want to do is check the "Type" column for type a and add all of the values found to give a total. Is this possible or do the columns need to be next to each other? I keep getting #VALUE.
Thanks!
Bookmarks