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 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!

excel

Formulas and Functions

Riny_van_Eekelen
Sep 03, 2022
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.

4 Replies

Riny_van_Eekelen
Platinum Contributor
Sep 03, 2022
Szymon960 Look into the SUMIF function. If you have already done that but didn't succeed, perhaps you can show the formula you tried.
- Szymon960
  Copper Contributor
  Sep 03, 2022
  =SUMPRODUCT(((B:B="bps044"))*(Summary!C:C=Summary!A10))
  
  This was my last attempt before I gave up.
  - Riny_van_Eekelen
    Platinum Contributor
    Sep 03, 2022
    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.

Forum Discussion

Data Collection