not calculating when i enter another criteria to the formula

[Patcheen]

Cant figure out where im going wrong

=SUMIFS($I$5:$I$1000,"delivered",t5:t1000,"Pm,",$C$5:$C$1000

this formula worked fine til i input the - t5:t1000,"Pm,"

it says you've entered too many arguments.

and when i put sumifs it says there is a problem with this formula

im at a loss.

TIA

 

[Michael M]

You don't have a closing bracket ?

 

[Michael M]

Maybe this is what your after.

=SUMIFS($C$5:$C$1000,T5:T1000,"delivered",T5:T1000,"Pm")

 

[SunnyAlv]

Try this. because the formula is reversed, so it's an error

=SUMIFS($I$5:$I$1000,T5:T1000,"Pm,",$C$5:$C$1000,"delivered")

or this

=SUMIFS($I$5:$I$1000,T5:T1000,"delivered",$C$5:$C$1000,"Pm,")

I don't know where the "deliver" column is and where the "pm" column is.

 

[Patcheen]

Thank you to both of you both solutions worked a treat

Thank you