SUMIF Formula returning 'O'

rdipaola

I'm using the following formula to sum invoice amounts, but its returning '0's

 

=SUMIF([Job #]$6:[Job #]$60, [Job #]62, [Current Amount Due]$6:[Current Amount Due]$60)

I have also tried

=SUMIF([Job #]$6:[Job #]$60, "18-030", [Current Amount Due]$6:[Current Amount Due]$60)

rdipaola

I was able to figure out the issue. The Job# for the invoice data had a period and the job numbers where I was totaling had a dash.