I have a several columns of data like this:
Date Place Good Bad
2001.1 US 10 15
2002.5 Mexico 5 10
I need it to add up all the "Good" numbers that were in Mexico on 2002.5. So it needs to check to criteria and then sum the numbers. Any ideas? I can do it with DSUM, but then I have to make lots of little tables. I want a series of columns for each week.
Chuck.
Bookmarks