SUMIF Formula returning 'O'

Options
rdipaola
rdipaola ✭✭
edited 12/09/19 in Smartsheet Basics

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)

Capture.JPG

Comments