Sep 03 2022 10:16 PM
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 contains Job# and $ amount per purchase.
I need information pulled from sheet #2 into #1 based on the job number sum up all for example 10 purchases. Needs to search through all purchases and only sum the specified job number $ amount.
Any help would be appreciated.
Thanks!
Sep 03 2022 10:24 PM
@Szymon960 Look into the SUMIF function. If you have already done that but didn't succeed, perhaps you can show the formula you tried.
Sep 03 2022 10:37 PM
Sep 03 2022 11:28 PM
Solution@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.
Sep 03 2022 11:36 PM - edited Sep 03 2022 11:38 PM
You're a genius. THANK YOU!!!
Sep 03 2022 11:28 PM
Solution@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.