Forum Discussion
Solved
Data Collection
Cant seem to figure out how to make any formula make this work. Sheet #1 contains a column with job #'s along with other totals pertaining each job. Sheet #2 contains thousands of purchases. It ...
Szymon960 Let's say the sheet with all the purchases is called "Purchases", enter this formula in B10 of the Summary sheet:
=SUMIF(Purchases!B:B,A10,Purchases!C:C)where A10 contains the Job# you want to summarize.
Szymon960 Look into the SUMIF function. If you have already done that but didn't succeed, perhaps you can show the formula you tried.
- =SUMPRODUCT(((B:B="bps044"))*(Summary!C:C=Summary!A10))
This was my last attempt before I gave up.Szymon960 Let's say the sheet with all the purchases is called "Purchases", enter this formula in B10 of the Summary sheet:
=SUMIF(Purchases!B:B,A10,Purchases!C:C)where A10 contains the Job# you want to summarize.
You're a genius. THANK YOU!!!
