This worked first time, thank you. I am so glad for the assistance that is
available here. Each of these responses has been unbelievably helpful . . .
and the project moves forward!

"T. Valko" wrote:

the month in G column equals 9

Assuming that column G contains DATES and not just the number 9

Try this array formula** :

=SUM(IF(FREQUENCY(IF((A1:A10=5)*(MONTH(G1:G10)=9)* (B1:B10<""),MATCH(B1:B10&"",B1:B10&"",0)),MATCH(B 1:B10&"",B1:B10&"",0))0,J1:J10))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

--
Biff
Microsoft Excel MVP


"Bigfoot17" wrote in message
...
Thnaks it took awhile. It turns out that I was missing a close
parenthesis
elsewhere in my formula.

My poject just got a lot more complicated for me as I need another
variable
thrown in. I need the sum of J column for the unique values in B column
when
A column equals 5 and the month in G column equals 9. Anyone care to take
a
shot at that? (My head hurts!).