Google Spreadsheet Post #1764
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Sep-19-2014
post by CIS Mentor:
(https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/zhnMThGBvWU)
How do I count cells based on a condition and extract that cell's data?
How do I count cells based on a condition and extract that cell's data (if it matches a condition), sort of like a COUNTIF but also adding that cell's data into a variable (for each occurrence) so I have a total.
For example cell has numbers (with values 1, 2 and 3) that meet the condition, and I want to store those values in an integer that will have the value 6 (alternatively, using an array to store each cell's value then looping through the array and storing the total through the iterations will work).
----------------------------------------------------------------------------------------------------------
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Sep-19-2014
post by CIS Mentor:
(https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/zhnMThGBvWU)
How do I count cells based on a condition and extract that cell's data?
How do I count cells based on a condition and extract that cell's data (if it matches a condition), sort of like a COUNTIF but also adding that cell's data into a variable (for each occurrence) so I have a total.
For example cell has numbers (with values 1, 2 and 3) that meet the condition, and I want to store those values in an integer that will have the value 6 (alternatively, using an array to store each cell's value then looping through the array and storing the total through the iterations will work).
----------------------------------------------------------------------------------------------------------
