+ Reply to Thread
Results 1 to 3 of 3

how to cellect diferent data form table (IF SUMIF COUNTIF MACH)

  1. #1
    Registered User
    Join Date
    02-11-2016
    Location
    Como, Italy
    MS-Off Ver
    2010
    Posts
    2

    Red face how to cellect diferent data form table (IF SUMIF COUNTIF MACH)

    Please I will real appreciate some help, I don’t know what function to use or how, I think I need IF SUMIF COUNTIF MACH, when I make invoice I collect this data in sheet

    A invoice no.
    B company name
    C adress
    D date invoice
    E date when need to pay
    F way of pay (cash;bank)
    D price

    I have made new table in new sheet whit filters but what functions to use in to collect data if I want to know amount from the same company or even how to arrange data (column/sheet) in new table, because I have a lot of data, and this will help me a lot whit my work
    Attached Files Attached Files

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,910

    Re: how to cellect diferent data form table (IF SUMIF COUNTIF MACH)

    I suggest to read about pivot tables. I think that will do what you want.
    Attached Files Attached Files
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  3. #3
    Registered User
    Join Date
    02-11-2016
    Location
    Como, Italy
    MS-Off Ver
    2010
    Posts
    2

    Re: how to cellect diferent data form table (IF SUMIF COUNTIF MACH)

    Thank you, it was so easy, I understand now ...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VBA index&mach through loop
    By cvelle89 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-18-2015, 05:54 AM
  2. COUNTIF, SUMIF, for a range of data
    By ufopilot in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-16-2014, 08:54 AM
  3. [SOLVED] Removing data from 2 diferent worksheets with the same macro???
    By ciapul12 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-18-2014, 03:35 PM
  4. [SOLVED] sort data and move it to diferent sheets
    By Ashrak in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-16-2013, 11:18 AM
  5. from value in combo box find data in 2 diferent sheets
    By cdafonseca in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-21-2013, 12:43 PM
  6. Get data from diferent workbooks to a single workbook
    By clixo in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 10-26-2010, 12:51 PM
  7. Lookup and mach
    By Esrei in forum Excel General
    Replies: 2
    Last Post: 06-19-2006, 11:25 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1