[Solved] Excel formula Sort& Sum

[Muh]

Excel Formula Required

Here Attach Data Sheet in 1st Sheet . Based On Colum "L" item Division Sales and Profit Amount Based On Employee name

Item Division Only 1 time seen Under 1 Employee Sales and Profit amount Sum

 

[shamimarita]

Excel Formula Required

Here Attach Data Sheet in 1st Sheet . Based On Colum "L" item Division Sales and Profit Amount Based On Employee name

Item Division Only 1 time seen Under 1 Employee Sales and Profit amount Sum

View attachment 1734

Hello Muh,

To fetch the sales and profit values for these Employee Name, and Item Division from the sales sheet, you can use the SUMIFS formula in Excel.

Sales Amount:
=SUMIFS('Sales Data'!$G$3:$G$163, 'Sales Data'!$J$3:$J$163, E4, 'Sales Data'!$L$3:$L$163, F4)

Profit Amount:
=SUMIFS('Sales Data'!$H$3:$H$163, 'Sales Data'!$J$3:$J$163, E4, 'Sales Data'!$L$3:$L$163, F4)