How can I count a range of non-blank rows based on criteria from a range of values in another column?
Column A has multiple occurances of values ranging from A through J in each row (ie: a,a,a,a,b,b,b,b,b,c,c,c,c,c,c,c,c,c,c,c,d,d,d,d,d,etc). orrucance rates of each value (a,b,c,etc) will vary and range length (# of rows) will vary.
Corresponding rows in column b are either blank or numeric values.
How can I either:
1)count the non-blank rows in coumn b based on a defined text value in column A (ex: all c's)
2)calculate an average of the values in column b based on all the occurances of a particular value in column A (ex: all c's)?
Column A has multiple occurances of values ranging from A through J in each row (ie: a,a,a,a,b,b,b,b,b,c,c,c,c,c,c,c,c,c,c,c,d,d,d,d,d,etc). orrucance rates of each value (a,b,c,etc) will vary and range length (# of rows) will vary.
Corresponding rows in column b are either blank or numeric values.
How can I either:
1)count the non-blank rows in coumn b based on a defined text value in column A (ex: all c's)
2)calculate an average of the values in column b based on all the occurances of a particular value in column A (ex: all c's)?