I was a little confused about what data was in which column and I also could
not get where the 1.5 is coming from. And the NG word-wrap doesn't help any!

"PCLIVE" wrote:

You're correct JMB. Originally it was not stated what other data might be
in columns E and G. That was a bad assumption on my part. However, the
solution you provided in your other post was what I was ultimately trying to
come up with (after the additional data was provided by the OP). Though in
their data provided, they listed one column as B instead of C, it was still
assumed that the column should have been C. Also, I'm sure you noticed that
the expected result of "1.5" does not match up to the result of what the OP
requested (the total of both columns E & G). My result came up with 2. I'm
sure that is why you listed one formula for totalling both columns and two
separate formulas to total individual columns.

Anyway, thanks for showing me the solution I was trying to come up with.
Regards,
Paul

"JMB" wrote in message
...
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".