I am trying to sum a column ("S") based on fulfilling 2 criteria in 2
other columns (C = A1 AND O = 1, 2, 3...12). I want to do this in a
formula rather than a DSUM since my criteria changes in 2 different
ways; Column C follows a cell reference, and Column O follows months 1
- 12.

Suggestions?

maybe
=sumproduct((c2:c22=a1)*(o2:o220)*(o2:o22<=12)*s2 :s22)

--
Don Guillett
SalesAid Software

"paul" wrote in message
oups.com...
I am trying to sum a column ("S") based on fulfilling 2 criteria in 2
other columns (C = A1 AND O = 1, 2, 3...12). I want to do this in a
formula rather than a DSUM since my criteria changes in 2 different
ways; Column C follows a cell reference, and Column O follows months 1
- 12.

Suggestions?

Thanks... I tried sumproduct and received the #num error or wacko
results with SUM(IF(...

=SUMPRODUCT((JDE=A24)*(Month=4)*USD)

JDE = Column C
Month = Column O
USD = summing all $$$
Month = discreet value to be changed by cell.

Don Guillett wrote:
maybe
=sumproduct((c2:c22=a1)*(o2:o220)*(o2:o22<=12)*s2 :s22)

--
Don Guillett
SalesAid Software

"paul" wrote in message
oups.com...
I am trying to sum a column ("S") based on fulfilling 2 criteria in 2
other columns (C = A1 AND O = 1, 2, 3...12). I want to do this in a
formula rather than a DSUM since my criteria changes in 2 different
ways; Column C follows a cell reference, and Column O follows months 1
- 12.

Suggestions?

Note that SUMPRODUCT doesn't work with complete columns, you have to specify
a range.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"paul" wrote in message
oups.com...
Thanks... I tried sumproduct and received the #num error or wacko
results with SUM(IF(...

=SUMPRODUCT((JDE=A24)*(Month=4)*USD)

JDE = Column C
Month = Column O
USD = summing all $$$
Month = discreet value to be changed by cell.

Don Guillett wrote:
maybe
=sumproduct((c2:c22=a1)*(o2:o220)*(o2:o22<=12)*s2 :s22)

--
Don Guillett
SalesAid Software

"paul" wrote in message
oups.com...
I am trying to sum a column ("S") based on fulfilling 2 criteria in 2
other columns (C = A1 AND O = 1, 2, 3...12). I want to do this in a
formula rather than a DSUM since my criteria changes in 2 different
ways; Column C follows a cell reference, and Column O follows months 1
- 12.

Suggestions?

Thanks!!!!!!!!!!!!!!

I guess it did not like my "NAMED" ranges... It worked when I used the
actual cell references.

=SUMPRODUCT(('Raw Data'!$C$2:$C$6270=$A2)*('Raw
Data'!$O$2:$O$6270=1)*'Raw Data'!$S$2:$S$6270)


Don Guillett wrote:
maybe
=sumproduct((c2:c22=a1)*(o2:o220)*(o2:o22<=12)*s2 :s22)

--
Don Guillett
SalesAid Software

"paul" wrote in message
oups.com...
I am trying to sum a column ("S") based on fulfilling 2 criteria in 2
other columns (C = A1 AND O = 1, 2, 3...12). I want to do this in a
formula rather than a DSUM since my criteria changes in 2 different
ways; Column C follows a cell reference, and Column O follows months 1
- 12.

Suggestions?

Thanks!!!!!!!!!!!!!!

I guess it did not like my "NAMED" ranges... It worked when I used the
actual cell references.

=SUMPRODUCT(('Raw Data'!$C$2:$C$6270=$A2)*('Raw
Data'!$O$2:$O$6270=1)*'Raw Data'!$S$2:$S$6270)


Don Guillett wrote:
maybe
=sumproduct((c2:c22=a1)*(o2:o220)*(o2:o22<=12)*s2 :s22)

--
Don Guillett
SalesAid Software

"paul" wrote in message
oups.com...
I am trying to sum a column ("S") based on fulfilling 2 criteria in 2
other columns (C = A1 AND O = 1, 2, 3...12). I want to do this in a
formula rather than a DSUM since my criteria changes in 2 different
ways; Column C follows a cell reference, and Column O follows months 1
- 12.

Suggestions?