tell me if this does what you ask
=IF(OR(E1=14, G1=14),IF(AND(C1="reason",A1=1),SUM(D:D),""),"")
=IF(OR(E1=14, G1=14),IF(AND(C1="reason",A1=1),SUM(G:G),""),"")
that assumes data is in the first row.
if this doesn't quite get it let us know what is going wrong/or i left out
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"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".