Hello,
I was wondering if it would be possible to count numbers in a column based on two conditions. I have my set of numbers, (2,4,0) and (5,17,10). I would like to count the numbers in column G if the numbers in column A are in the same set of numbers and the cell next to column A that is the cells in F are true.
The purpose of this is to help me calculate the percentage of the numbers in G separately based on the set of numbers. What I have is the overall percentage. So column Q count the numbers in G divide each by the total count and multiply by 100.
=IF(Q4=0,"",(Q4/$Q$10)*1)
And for the set of numbers the expected output would the values in S and T. If I can get the count, then i can calculate the percentage. Thanks
Cross-posted at: How to count numbers in a column based on a set of numbers
I was wondering if it would be possible to count numbers in a column based on two conditions. I have my set of numbers, (2,4,0) and (5,17,10). I would like to count the numbers in column G if the numbers in column A are in the same set of numbers and the cell next to column A that is the cells in F are true.
The purpose of this is to help me calculate the percentage of the numbers in G separately based on the set of numbers. What I have is the overall percentage. So column Q count the numbers in G divide each by the total count and multiply by 100.
=IF(Q4=0,"",(Q4/$Q$10)*1)
And for the set of numbers the expected output would the values in S and T. If I can get the count, then i can calculate the percentage. Thanks
Cross-posted at: How to count numbers in a column based on a set of numbers
Last edited by a moderator:
