Forum Discussion

null null's avatar
null null
Copper Contributor
Apr 09, 2018

Excel Formula Assistance Needed

I am trying to create a formula and I cannot seem to figure it out....

 

See Attached photo, I would like to create an "if" formula to tally a specific salespersons profit. I need to formula to identify the specific salesperson from Column I and then add together the profit from Column P to give me a total based on the specific person.

 

Any help would be appreciated!!!

Formulas & Functions
Need Help

2 Replies

Sort By
  • IngeborgHawighorst's avatar
    IngeborgHawighorst
    MVP
    Apr 09, 2018

    Hello,

     

    you could use a pivot table. Drag the Sales Consultant column into the Rows area and the Front Gross into the Values area and the data will be summarized by Sales Consultant.

  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    Apr 09, 2018

    Hi,

     

    That could be like

    =SUMIF(I:I,"Person Name",P:P)

    or reference on the cell with person name

Resources