Thread: [Solved] Wanting to get data from one cell and and add the data from corresponding cell
View Single Post
 
Old 11-17-2016, 11:58 AM
xor xor is offline Windows 10 Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,102
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
If you want to sum values in G1:G25 where E1:E25 and F1:F25 = 2 then:

=SUMIFS(G1:G25,E1:E25,2,F1:F25,2) or

=SUMPRODUCT((E1:E25=2)*(F1:F25=2)*(G1:G25))

Instead of hard coding 2 in the formulas you can of course refer to a cell and then put 2 or another number in that cell.
Reply With Quote