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 |

+2

VotesUse 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 |

+3

VotesD4 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 |

+5

VotesBe sure to find shortcuts when you use it frequently

Ryan Lewis- December 7, 2018 |