Thread: [Solved] Selecting a value after matching two conditions
View Single Post
 
Old 02-18-2020, 02:08 AM
Marcia's Avatar
Marcia Marcia is offline Windows 7 32bit Office 2013
Expert
  
Join Date: May 2018
Location: Philippines
Posts: 527
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default
In D2 of Table 1, paste this formula
=SUMIFS(table2!$D$2:$D$10,table2!$A$2:$A$10,$A6,ta ble2!$C$2:$C$10,$C6)
Copy down
Reply With Quote