Forum Discussion
Solved
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...
=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
=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