OK this should be the last variation ...

I need to sum the number of different jobs in Column G that have "WAL-MART STORES, INC" in Column H. I figure this can't be much different than what you already provided me with but I can't seem to get it to work.

=SUM(IF(IF(MATCH($T$2:$T$1079&$H$2:$H$1079&$G$2:$G$1079,$T$2:$T$1079&$H$2:$H$1079&$G$2:$G$1079,0)=(ROW($T$2:$T$1079)-ROW(T2)+1),IF($T$2:$T$1079="SOUTH ATLANTIC",IF($T$2:$T$1079<>"WAL-MART STORES, INC",(ROW($T$2:$T$1079)-ROW($T$2)+1),0)<>0,0)),1,""))