Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Matching data in Excel (https://www.askmehelpdesk.com/showthread.php?t=514127)

  • Oct 6, 2010, 10:48 AM
    priesm2
    Matching data in Excel
    I currently have 2 different tables. One has a list of customers and their locations, and the other has a list of customers and how much product they ordered over the year. Not all customers made orders throughout the year. How can I match up the customers with how much they ordered?

    Thanks!
  • Oct 7, 2010, 07:01 AM
    JBeaucaire

    The functions COUNTIF() and SUMIF() will most likely be what you need to use.

    • All times are GMT -7. The time now is 05:16 AM.