Search:

Type: Posts; User: PFS12; Keyword(s):

Search: Search took 0.00 seconds; generated 55 minute(s) ago.

  1. Re: Need EXCEL To go get info for me and return dollars

    That is exactly what my problem was, Thank you! Maybe you can shed some light on to one more thing for me, and I apologize for being a noob here. When I download my sheet with the information on it...
  2. Re: Need EXCEL To go get info for me and return dollars

    Sergio,

    I appreciate the effort here, there are more codes for me to add and I will need to expand on it from time to time, if I one more cell to either formula I get #value as the answer. Did...
  3. Need EXCEL To go get info for me and return dollars

    This is going to be long and tedious, or I am just simple minded. I would like to have a database of information (Control) on one sheet, and import data on another sheet, and have a formula compare...
  4. Replies
    8
    Views
    694

    Re: SUMIFS Across Multiple Columns

    I found that my issue was the columns needed to match in the search field, once I did that I think I can use this in the capacity you intended.

    Thank you very much
  5. Replies
    8
    Views
    694

    Re: SUMIFS Across Multiple Columns

    Sorry for the delay as I am just now able to get back to this. This didn't work either. I tried several different ways with this formula, it either gets me an N/A result or #value . I tried adding...
  6. Replies
    8
    Views
    694

    Re: SUMIFS Across Multiple Columns

    This did not work
  7. Replies
    8
    Views
    694

    SUMIFS Across Multiple Columns

    I have a formula that is getting out of hand. At first I found it to work without and issue but now I have to replicate it a little more frequently and its getting quite cumbesome to do so.

    I...
  8. Re: Need to Sum a column if another column contains a Letter followed by numbers

    Thank you sir!
  9. Need to Sum a column if another column contains a Letter followed by numbers

    <tbody>
    R04973
    LEICA 2DEXC KIT & PA
    20180219
    $0.00
    $0.01
    MI
    $0.01
    1
  10. Replies
    8
    Views
    129

    Re: SumIFs Formula issue

    Please explain?

    It Definitely works, I'm just wondering why. Thank you for the help
  11. Replies
    8
    Views
    129

    Re: SumIFs Formula issue

    I could, but I have multiple salesmen that I am tracking, so this is just an example of one person, so I'd have to write multiple "helper" columns. there has to be a way to do this, I was thinking...
  12. Replies
    8
    Views
    129

    SumIFs Formula issue

    <colgroup><col span="2"><col><col><col><col><col><col><col></colgroup><tbody>
    Salesman #
    Responsible
    Vendor / Invoice #:
    Description:
    Date:
    Average Cost
    Price:
    Vendor #
    Sell Price:
  13. Thread: I need some help

    by PFS12
    Replies
    3
    Views
    171

    Re: I need some help

    OK so I still need help on this, I have been on this all day and just when I thought I had it, I reconstructed my whole table, and then found out that I am not referencing the actual value of the...
  14. Thread: I need some help

    by PFS12
    Replies
    3
    Views
    171

    Re: I need some help

    Close, but I can't ignore the value of B. I am bringing it back in as an "in house" charge, so it does have to reflect a dollar amount being taken off the total I just can't ignore it. Almost like I...
  15. Thread: I need some help

    by PFS12
    Replies
    3
    Views
    171

    I need some help

    <tbody>
    Branch

    Sell Price

    Qty



    2
Results 1 to 15 of 15