Friday, September 19, 2014

yogi_Compute Total Time In Minutes By User From A Table Of StartTime EndTime And UserName

                      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).

----------------------------------------------------------------------------------------------------------