Welcome Guest.
Asked by: Amanda Cook 222 views Software December 4, 2018
Everyone wants to learn how many jobs in a certain team in Table 1 correspond to Table 2. What formula is used?
+2Votes
Use SUMIF to solve your confusion:
=COUNTIFS($F$3:$F$1000,$C4,$M$3:$M$1000,D$4)
Then you can pull and pull down the formula
(Note: Modify the number of rows according to the actual table )
Helen- December 5, 2018 |
+3Votes
D4 cell formula: =countifs (Table 1! F: F, $C4, Table 1! M: M, D$2) Then right pull, fill it out.
Kenneth Martin- December 6, 2018 |
+5Votes
Be sure to find shortcuts when you use it frequently
Question: Is this second form convenient for statistics? The trouble master is pointing
Question: The formula of the meeting is really…
Ryan Lewis- December 7, 2018 |
+2Votes
Use SUMIF to solve your confusion:
=COUNTIFS($F$3:$F$1000,$C4,$M$3:$M$1000,D$4)
Then you can pull and pull down the formula
(Note: Modify the number of rows according to the actual table )
+3Votes
D4 cell formula: =countifs (Table 1! F: F, $C4, Table 1! M: M, D$2)
Then right pull, fill it out.
+5Votes
Be sure to find shortcuts when you use it frequently