1 Reply Latest reply on May 23, 2015 3:02 PM by try67

    Can someone assist me with converting an Excel Expense Form?

    joelrb70

      I have been asked to convert our Expense Form to a PDF version to save paper and allow for digital signatures.  I can get the form to do the basic calculations for the Total Expense, but I need help on the ‘SUMIF’ part of “Less Compay Paid” and “Less Advances” lines


      Less Compay Paid is the amount if ‘Corp Paid’ and ‘Corp CC’ is selected in the ‘PAY METH’ column

      Less Advances is the amount if ‘Advance’ is selected in the ‘PAY METH’ column


      Any help would be very appreciated!

       

      I have added a link to what I have so far and the spreadsheet as an example.

       

      https://www.dropbox.com/s/bjdvzz0cox4djl4/Expense%20Form.pdf?dl=0

       

      https://www.dropbox.com/s/ojdza8s5efwoy0k/Expense%20Form.xlsx?dl=0