yogi_Multi Criteria Summing From Filtered Data

Google Spreadsheet   Post  #2160

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   May-08-2017

question by maddy:

https://productforums.google.com/forum/#!topic/docs/GSYwdTbjcqw;context-place=mydiscussions
Identify column headers for cells that meet criteria in a range
OK.. cant  figure out why.

for the first condition if I delete and paste the same value i.e., 2 in D1, it returns correct value.

Shouldnt it by default take 2 the first  time itself.

SHEET

**you can take a copy of the tab to test