Shimont109
New Member
- Joined
- Sep 19, 2022
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Hey!
I'm having a little struggle with a formula and I was hoping you could help me out
This is what i'm trying to do:
I have three active tables.
Table 1 is the main one and it is concentrated by a job number, Table 2 is for active jobs and the amount of money spent on them, after the job is completed it moves to table 4 which contains all the finished jobs.
My goal is to show on table 1 the sum amount paid per job whether it's completed or not.
I'm using this formula:
=IF(VLOOKUP([@[Job '#]],Table2,1,FALSE),SUMIF(Table2,[@[Job '#]],Table2[PO Sum]),SUMIF(Table4,[@[Job '#]],Table4[PO Sum]))
But something is wrong with it, it calculates correctly if the job is still active, however, it won't calculate the inactive jobs.
Help.
I'm having a little struggle with a formula and I was hoping you could help me out
This is what i'm trying to do:
I have three active tables.
Table 1 is the main one and it is concentrated by a job number, Table 2 is for active jobs and the amount of money spent on them, after the job is completed it moves to table 4 which contains all the finished jobs.
My goal is to show on table 1 the sum amount paid per job whether it's completed or not.
I'm using this formula:
=IF(VLOOKUP([@[Job '#]],Table2,1,FALSE),SUMIF(Table2,[@[Job '#]],Table2[PO Sum]),SUMIF(Table4,[@[Job '#]],Table4[PO Sum]))
But something is wrong with it, it calculates correctly if the job is still active, however, it won't calculate the inactive jobs.
Help.