DSUM only allows one criteria to be created?
Posted by Anne Huang on November 22, 2001 7:00 AM
I've been trying to figure out the DSUM function. From what I understand, you need to type in the criteria in table format in your worksheet with the column heading and the criteria in the cell underneath.
Where A1 would be column heading (i.e. Trees) and A2 would be criteria (i.e. Apples) and in the DSUM function A1:A2 would be the criteria cell range. However, I would like to be able to "list" all my criteria under A1 (Trees), for example A2=Pears, A3=Cherries etc.
How do I account for this when defining my criteria cell range? The reason I need to do this is because I'm trying to sum numbers related to certain cost centres in the organization and there are over 95 cost centres to take into account.
Any ideas?