Monday, May 8, 2017

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.



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