Forum Discussion

sboland61's avatar
sboland61
Copper Contributor
Sep 16, 2021
Solved

Do a search/sort/sum in an excel workbook and put results in another workbook

I am not an in depth excel user.  I am working with one excel file with multiple workbooks.   In WORKBOOK1, i need to search COLUMN D for all values = to VALUE1.  In each row with COLUMND = VALUE...
excel
Formulas and Functions
  • sboland61's avatar
    sboland61
    Sep 19, 2021
    Just pouring through this now...it is perfect, thank-you!! still playing with how i can expand etc. YOU ROCK
sboland61's avatar
sboland61
Copper Contributor
Sep 19, 2021
got the tables in and cleaned some other things up. I cannot get the other tab totals (Sharon, Suzanne, Capitol One, Mountain West and Monthly Operations to add up and map over to summary tab. I thought i would be able to replace the tab names in the formula from Cindy - > Sharon (for each tab). the formula: =SUMIF(Sharon[CODE],D$4,Cindy[HOURS]) results in an error. What is D$4?

Resources