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!!!!!!!!!
|