Sum if checked help

Angie M Graham

Can someone help me with this formula?

I want to sum Net pay if approval is checked

I have tried

=sumif(payapproval1:payapproval9, 1, netpay1:netpay9)

=sumif(payapproval1:payapproval9, =1, netpay1:netpay9)

=sumif(payapproval1:payapproval9, "yes" netpay1:netpay9)

And a few other variations and I get "unparceable"

Mark Cronk

Try:

=sumif([pay approval]:[pay approval], 1, [net pay]:[net pay])

Mark