Google Spreadsheet Post #2159
SUMIFS providing correct values only when I delete&paste the same value
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. May-07-2017
question by CAB05:
https://productforums.google.com/forum/#!topic/docs/UFZB8NZBMAE;context-place=forum/docsSUMIFS providing correct values only when I delete&paste the same value
I have used an index/match/max filter to identify column headers of cells with a value greater than zero in a given range. This works fine when there is only one such cell in a range. But what if there are multiple cells with a value greater than zero in a range? Is there a formula I can use to identify all column headers for all cells with values greater than zero in a given range?
No comments:
Post a Comment