Avatar of maryj152

asked on 

Calculate summary in one column based on value in another one in Excel 2010

Tried this formula based on one I found on this site. Mine doesn't work.
I want to enter the account numbers in the top summary area and get all of the values from the PO. Trying just one page for now but would like to be able to do it from all 3 pages for larger POs.
=SUMPRODUCT(($A$18:$A$39 =E10)*($J$18:$J$39))
Microsoft ExcelSpreadsheets

Avatar of undefined
Last Comment
barry houdini

8/22/2022 - Mon