excel - Trying to set up a summary sheet for data validation -
i've created workbook friend owns own business. workbook includes sheet each month, data validation determine service, price, products, etc. indicates method of payment.
she's asked update summary sheet not show totals per month, show total each method of payment.
i'm having hard time finding right way this. since change each client, imagine i'll have sort of if statement, don't have enough experience able write out (at least not in excel).
any appreciated. thanks!
Comments
Post a Comment