Thread: Sum specific column rows based on 2 different column criteria
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jack jack is offline
external usenet poster
  
Posts: 186
Default 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!!!!!!!!!



Reply With QuoteReply With Quote