Welcome Guest.


Spreadsheet formula problem

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?

3 Answers

  1. +2Votes  

    Use SUMIF to solve your confusion:


    Then you can pull and pull down the formula

    (Note: Modify the number of rows according to the actual table )

    Helen- December 5, 2018 |

  2. +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 |

  3. +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 |