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.
Your description is not very clear...
You wrote: Less Compay Paid is the amount (which amount?) if ‘Corp Paid’ and ‘Corp CC’ is selected (how can both options be selected in a single drop-down?) in the ‘PAY METH’ column (there are multiple rows in the file with this column. To which ones does this apply?)
Same goes for the other description.