KristiGohs81
New Member
- Joined
- Dec 30, 2020
- Messages
- 5
- Office Version
- 2016
- Platform
- Windows
Good Moring All!
I am looking to reference a separate table on a separate worksheet in the same workbook. I would like to total all hours worked for one specific job code in the table. The formula is below: What am I missing?
Too few arguments???
=SUMIFS(TblGPH[Hours],TblGPH[Job],[@Job],SUMIFS(TblHLH[Hours],TblHLH[Job],[@Job]))
Thanks for all of your help! I am new at learning all of this and trying to power through.
I am looking to reference a separate table on a separate worksheet in the same workbook. I would like to total all hours worked for one specific job code in the table. The formula is below: What am I missing?
Too few arguments???
=SUMIFS(TblGPH[Hours],TblGPH[Job],[@Job],SUMIFS(TblHLH[Hours],TblHLH[Job],[@Job]))
Thanks for all of your help! I am new at learning all of this and trying to power through.