Help! Stuck on DSUM with multiple criteria...

[tbraswell]

I have multiple project #s that have multiple job #s for each project #. Each job has a certain amount of hours allocated to it. I need to determine how many hours by Job # have been allocated to each project and then it's percentage. See sample output. Please note that I have a table with Job #s, Project #s, and Hours. I have tried to use the DSUM formula but I can't figure out how to use it with multiple criteria. I hope this is an easy question for the experts.

ProjectNum	JobNumber	JobPct	30510_Job	30510_Proj	30510_Total
CHRTNY2018	1023158	84.0%	746.93	192.36	939.29
CHRTNY2018	1023159	16.0%	148.75	36.64	185.39
NGUSAS2018	1023795	1.7%	94.75	12.09	106.84
NGUSAS2018	1023796	21.2%	1,266.80	151.18	1,417.98
NGUSAS2018	1023797	75.1%	675.77	534.94	1,210.71

[ranman256]

make Q1 to sum the items,
make Q2 to get the Total / proj
then make Q3, using Q1 & Q2 and you can calc your % / proj.

then you can make Q4 to show your crosstab shown above.

[tbraswell]

Thank you for the quick response and simple answer. It worked! Sometimes I can't see the forest for the trees!