Sumproduct with 2 criteria

[Hélio]

Hi there, I´m facing a problem that i really thought a could surround but can´t. i have a list and need to sum the column week day based on a second criteria regarding a System name. the common formula used is not working what made me confused. I tried different arguments but failed..

please see attached for better understanding.

My best regards,

 

[Luke M]

You had a misplaced parenthesis, and array sizes were different. Formula in H5 should be:
=SUMPRODUCT((LEFT($A$2:$A$35;2)=H$4)*($D$2:$D$35=$G5))
Copy down and to the right as needed to fill in the table.

 

[Hélio]

Hi Luke, you are absolutely correct!! Im spending many hours a day to complete this table and details are trickling through my fingers...

My best regards

 

[Hui]

You may want to have a read of this post which explains how Sumproduct works
http://chandoo.org/wp/2011/05/26/advanced-sumproduct-queries/

 

[Syedali]

pfa