If E1 is 12 and G1 is 2, then it will be included in the total. I think the
condition is that col E is 14 and/or col G is 14 not the sum of cols E and G
is = 14.

"PCLIVE" wrote:

If the criteria is met based on if the row in column E OR G (not AND) is
"14", then you can try the following:

=SUMPRODUCT(--(A1:A550=1),--(C1:C550="reason"),--(E1:E550+G1:G55013),D1:D550+F1:F550)

HTH,
Paul


"PCLIVE" wrote in message
...
Did you try my suggestion?

=SUMPRODUCT(--(A1:A550=1),--(C1:C550="reason"),--(E1:E550=14),--(G1:G550=14),D1:D550+F1:F550)


"sharon t" wrote in message
...

This is close but...

I need to sum column D1:D550 and column F1:F550 based on criteria in
column
A,C,E and G rows 1 thru 550 for each of the four columns. What I have not
been able to do with Conditional Sum is to total the data in two columns
based on the criteria in the other 4 columns. Thanks.

"John Bundy" wrote:

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