Sum specific column rows based on 2 different column criteria
 

I need to sum specific column square footages (I), based on specific project
type (C) and region (B). this is what I currently have based on other posts.

=SUMPRODUCT('Active Projects'!I2:I300,'Active
Projects'!B2:B300=Dashboard!D14,'Active Projects'!D2:D300=Dashboard!C15)

Result = 0


I've also used this:
=SUMPRODUCT(('Active Projects'!B2:B300=Dashboard!E14)*('Active
Projects'!D2:D300=Dashboard!C15)*'Active Projects'!I2:I300)

Result = #Value!


HELP!!!!!!!!!

Sum specific column rows based on 2 different column criteria
 

=SUMPRODUCT(--('Active Projects'!B2:B300=Dashboard!E14),--('Active
Projects'!D2:D300=Dashboard!C15),('Active Projects'!I2:I300))

I guess a big key is to make sure you have no errors in the I2:I300 column
that it is trying to sum.
--
John C


"Jack" wrote:

I need to sum specific column square footages (I), based on specific project
type (C) and region (B). this is what I currently have based on other posts.

=SUMPRODUCT('Active Projects'!I2:I300,'Active
Projects'!B2:B300=Dashboard!D14,'Active Projects'!D2:D300=Dashboard!C15)

Result = 0


I've also used this:
=SUMPRODUCT(('Active Projects'!B2:B300=Dashboard!E14)*('Active
Projects'!D2:D300=Dashboard!C15)*'Active Projects'!I2:I300)

Result = #Value!


HELP!!!!!!!!!

Sum specific column rows based on 2 different column criteria
 

Worked, thank you very much!

"John C" wrote:

=SUMPRODUCT(--('Active Projects'!B2:B300=Dashboard!E14),--('Active
Projects'!D2:D300=Dashboard!C15),('Active Projects'!I2:I300))

I guess a big key is to make sure you have no errors in the I2:I300 column
that it is trying to sum.
--
John C


"Jack" wrote:

I need to sum specific column square footages (I), based on specific project
type (C) and region (B). this is what I currently have based on other posts.

=SUMPRODUCT('Active Projects'!I2:I300,'Active
Projects'!B2:B300=Dashboard!D14,'Active Projects'!D2:D300=Dashboard!C15)

Result = 0


I've also used this:
=SUMPRODUCT(('Active Projects'!B2:B300=Dashboard!E14)*('Active
Projects'!D2:D300=Dashboard!C15)*'Active Projects'!I2:I300)

Result = #Value!


HELP!!!!!!!!!

Sum specific column rows based on 2 different column criteria
 

You are welcome, and thanks for the feedback.
--
John C


"Jack" wrote:

Worked, thank you very much!

"John C" wrote:

=SUMPRODUCT(--('Active Projects'!B2:B300=Dashboard!E14),--('Active
Projects'!D2:D300=Dashboard!C15),('Active Projects'!I2:I300))

I guess a big key is to make sure you have no errors in the I2:I300 column
that it is trying to sum.
--
John C


"Jack" wrote:

I need to sum specific column square footages (I), based on specific project
type (C) and region (B). this is what I currently have based on other posts.

=SUMPRODUCT('Active Projects'!I2:I300,'Active
Projects'!B2:B300=Dashboard!D14,'Active Projects'!D2:D300=Dashboard!C15)

Result = 0


I've also used this:
=SUMPRODUCT(('Active Projects'!B2:B300=Dashboard!E14)*('Active
Projects'!D2:D300=Dashboard!C15)*'Active Projects'!I2:I300)

Result = #Value!


HELP!!!!!!!!!