Former Formula excel automatically equate to add it?
ABCDE
“workers
code-named” 1 on February results of the formula
1 1 95 COUNTIF ($ B $ 2:$ C $ 331,1)
2 3 5 COUNTIF ($ B $ 2:$ C $ 331 , 2)
3 35 28 COUNTIF ($ B $ 2:$ C $ 331,3)
……
100 9 76 COUNTIF ($ B $ 2:$ C $ 331100)
B2 -C331 is 331 workers in January-February receive prize money, prize money for at least 1 yuan, up 100 yuan, D statistics as of 1 yuan workers on several occasions the formula, E as a result of the D out, are there ways to In the D2-D331 automatically added it equate
“Edit – to replace” menu, look for COUNTIF, replace = COUNTIF On the line
Leave a Reply
You must be logged in to post a comment.