Adding Up $ Values Based On Criteria In Other Cells

Thank You, Thank You for your help! I'll try to give as much detail as possible without going into overkill.

In the attached example, I am tracking the quotes from various sales people. The MASTER sheet contains the raw data and the TEST sheet will contain a variety of statistics based on that raw data. The MASTER sheet had a TON of data, so I've shortened the list significantly.

- TEST E46 shows all of the quotes in which MASTER column J shows values under 10000, MASTER column I shows a date with the year equal to TEST E1 (2007), MASTER column L = "A", MASTER column M shows a date with the year equal to TEST E2 (2006). The result, as you see is 92.

- TEST E47 shows all of the quotes in which MASTER column J shows values under 10000, MASTER column I shows a date with the year equal to TEST E2 (2006), MASTER column M shows a date with the year equal to TEST E1 (2007). The result being 439.

- TEST E48 to TEST E53 shows similar information but with the values changing as show.

- TEST F46 to F56 shows the same information but only when "AJB" appears in TEST column H.

Moving to the next set just below the previous...

- TEST G59 shows those quotes where MASTER column J shows values under 10000, MASTER column L shows a "D", MASTER column M shows a date with the year equal to TEST F57 (2007)

The rest of the data in this set corresponds as shown. (I'm trying to spare you from overkill)

FINALLY TO MY PROBLEM ...

In the data sets just to the right of these I need to show dollar values of these quotes from column J instead of the number.

For example, TEST Q46 needs to show the dollar value of the 92 quotes in TEST E46. As I said, those dollar values are in MASTER column J.

I then need to do the same for all the corresponding cells for these data sets.

Again, Thank You, Thank You For Your Help.

Joe

I'll give it a try. Thank You Nathan