- bacteria cell
- viral load count
- web hosting features
One column has list of priority features, second column has 1, and 2 in it, indicating which priority is first and which one is second. Third column has 1 and 0 indicating, 1 as "yes that feature exists" and 0 as "no that feature does not exist". At the end of the 3 column I need a formula to show how many of First Priority Features are none existent, meaning, how many of the features in the colum 3 are of value "0", on the same row where second column has value of "1". tried vlokup and sumif.. cant get it on help too. Thanks for any hint :)
EXCEL find and count values in a column that are provided they meet the conditions in another column?
没有评论:
发表评论