Sum Unfinished Orders

[Sooner4Life]

Hello,

This one is kinda complicated.. I have a spreadsheet with 4 different conditional formatting rules that will highlight the row yellow if any are true. The highlighted rows let me know that the item still needs to be checked in.

=IF((($N3<>"")*($S3="")*($T3=0)*($H3<>"")),TRUE,FALSE)

=IF((($N3<>"")*($R3="")*($T3>0)),TRUE,FALSE)

=IF((($H3<>"")*($R3="")*($T3>0)),TRUE,FALSE)

=IF((($T3=0)*($R3="")),TRUE,FALSE)

On a separate sheet named Summary I would like to a total amount of all highlighted rows. Below is a horrible example just to kinda give you a direction of what I'm thinking..

=SUM(IF((IF((Ada!$N3:$N5000<>"")+(Ada!$S3:$S5000="")+(Ada!$T3:$T5000=0)+(Ada!$H3:$H5000<>""),1)+(IF((Ada!$N3:$N5000<>"")+(Ada!$R3:$R5000="")+(Ada!$T3:$T5000>0),1)+(IF((Ada!$H3:$H5000<>"")+(Ada!$R3:$R5000="")+IF((Ada!$T3:$T5000>0)+(Ada!$T3:$T5000=0)+(Ada!$R3:R500=""),1))

 

[Sooner4Life]

Not seeing a way to edit my post.. I guess I worded that wrong. I meant separate tab not sheet.

 

[Sooner4Life]

I was able to figure it out myself. The formula I used is:

={SUM((IF((Ada!$N$3:$N$5000<>"")*(Ada!$S$3:$S$5000="")*(Ada!$T$3:$T$5000=0)*(Ada!$H$3:$H$5000<>""),1)),+IF((Ada!$N$3:$N$5000<>"")*(Ada!$R$3:$R$5000="")*(Ada!$T$3:$T$5000>0),1),+IF((Ada!$H$3:$H$5000<>"")*(Ada!$R$3:$R$5000=""),1),+IF((Ada!$T$3:$T$5000>0)*(Ada!$T$3:$T$5000=0)*(Ada!$R$3:R$5000=""),1))}