I finally had time to get back on this project and finish it. Following is
the formula that I came up with and it works. Thanks all!

=SUM(IF('2007 Link'!$E$2:$E$800=44,IF('2007 Link'!$A$2:$A$800=1,IF('2007
Link'!$C$2:$C$800="red",'2007 Link'!$D$2:$D$800,0),0),0))+SUM(IF('2007
Link'!$G$2:$G$800=44,IF('2007 Link'!$A$2:$A$800=1,IF('2007
Link'!$C$2:$C$800="red",'2007 Link'!$F$2:$F$800,0),0),0))

"sharon t" wrote:

I want to sum colums D and F based on specified criteria in colums A, C, E
and G.

Sum "Total # Br 1" and "Total # Br 2" (colums D and F) if colum A is "1",
column C is "reason", column E is "14" and/or Column column G is "14".