SUMIF INDEX MATCH-please hhh : I am trying to look up and sum up values on a another excel sheet where the sum up values are with certain criterias in a row. Example below where criteria 1=date in Column D, criteria 2= "SUB" or "RED" in column F.
I am not sure whey my formula does not work at the sum stage, pleas help help help....
[enter image description here][1]

[enter image description here][2]



 


  [1]: https://i.stack.imgur.com/CA39Z.png
  [2]: https://i.stack.imgur.com/TiPzL.png