SOLVED

# Get total value from different sheet for a specific Cell value.

Copper Contributor

# Get total value from different sheet for a specific Cell value.

Sheet 1 i.e Employee Details & Sheet 2 i.e Raw Data.

In the Raw data sheet, there are two types of products GT & ST.

All the products come in GT Except that red highlighted text i.e Zopper Extended Warranty that comes in ST. (Note- There are multiple types of Zopper Products are are comes in ST)

Now the question is

I want to find the total sales amount of GT & ST in GT & ST Value Column (Employee Details Sheet) for a particular salesman with the help of the Raw Data Sheet where all the sales and their amount are available. so that I could compare whether he completed his GT & ST target or not.

Raw Data (Sheet 2)

Sheet 1 (Employee Details)

best response confirmed by Shaqibiqbal007 (Copper Contributor)
Solution

# Re: Get total value from different sheet for a specific Cell value.

``=SUMPRODUCT(ISNUMBER(SEARCH("Zopper Extended Warranty",'Raw Data'!\$H\$2:\$H\$14))*('Raw Data'!\$G\$2:\$G\$14=A2)*'Raw Data'!\$M\$2:\$M\$14)``

You can try SUMPRODCT.

RAW DATA

Employee Details

1 best response

Accepted Solutions
best response confirmed by Shaqibiqbal007 (Copper Contributor)
Solution

# Re: Get total value from different sheet for a specific Cell value.

``=SUMPRODUCT(ISNUMBER(SEARCH("Zopper Extended Warranty",'Raw Data'!\$H\$2:\$H\$14))*('Raw Data'!\$G\$2:\$G\$14=A2)*'Raw Data'!\$M\$2:\$M\$14)``

You can try SUMPRODCT.

RAW DATA

Employee Details