Need Formula that dosent count if the adjacent cell was already counted in

Try

=SUM(IF(((H1:H1000<=-24)+(I1:I1000=-24)+(L1:L1000=-24)+(O1:O1000<=-24)),1,0))

Entered with Ctrl+Shift+Enter

I defined the ranges rather than whole columns as it is an array formula so there are performance considerations.

Didn't work.

Worked on a sample I used (assuming I understood your requirement correctly). any row will only return 1 even if there 4 entries in it,

Post a sample file showing expected results.

I suggest a helper column

Say column P on the Admission tab for example.

In P2 and filled down put
=MIN(H2,I2,L2,O2)

Now use
=COUNTIF(Admission!P:P,"<=-24")

Wait, the MIN part would return alot of 0's if the H I L and O cells are empty..
Change that to
=IF(COUNT(H2,I2,L2,O2),MIN(H2,I2,L2,O2),"")

Didn't work.
It is still double counting the numbers.

Can you attach a sample file showing about 10 rows or so, plus your expected results?

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window (or use the paperclip icon).

I am attaching a the file, everything in light red I need it to only count once, for example if a cell in Column H is light red and a cell in column I,L, or O is light red it only counts as one and not 4. This is what I a formula for. I made references to specific rows in the attachment they are row 128 and row 150. They have arrows pointing to referenced cells.
Thank you in advance for any help.
When trying to view the attachment you have to down load it first. And then go to the Admission Worksheet.

I just attached a the file

I can't say I understand what the formula is supposed to be doing.
But I'd suggest a helper column, in say column P
P2 and filled down put

=MIN(H2,I2,L2,O2)

Then (assuming the rest of your formula does what you want)
=COUNTIF(Admission!P:P,"<=-24")+COUNTIF(Admission!H:H,"#")+COUNTIF(Admission!I:I,"#")+COUNTIF(Admission!L:L,"#Value!")+COUNTIF(Admission!H:H,">720")+COUNTIF(Admission!I:I,">720")

I want it to count the cells highlighted in light red because they are out of compliance. But I don't want it to double count cells if two cells in any row are highlighted light red. I guess that might make more sense. I was saying columns before.

See results highlighted in green in column P (P128/P150) using my original formula: results of 1 !!!!!

=IFERROR(SUM(IF((($H$1:$H$1000<=-24)+($I$1:$I$1000=-24)+($L$1:$L$1000=-24)+($O$1:$O$1000<=-24)),1,0)),"")

That is working so far but I also need it to count cells that contain #VALUE! and cells that contain "#" but still not double count them.

Or I have still misunderstood your requirement?

I think formula could be ...

=IFERROR(SUM(IF((($H2<=-24)+($I2<=-24)+($L2<=-24)+($2<=-24)),1,0)),"")

Just check individual rows: Still same result.

I figured it out. The Working Formula is.

=IFERROR(SUM(IF((($H$1:$H$1000<=-24)+($H$2:$H$1000="#")+($I$1:$I$1000<=-24)+($L$1:$L$1000<=-24)+($L$2:$L$1000="#")+($O$1:$O$1000<=-24)),1,0))," ")

Try ..

=IFERROR(SUM(IF(($H2<=-24)+($I2<=-24)+($L2<=-24)+($O2<=-24)+($H2="#")+($I2="#")+($L2="#")+($O2="#"),1,0)),"")

#VALUE will raise an error condition so IFERROR will return 1 (rather than blank in previous formula).

I figured it out the final working formula is...

=IFERROR(SUM(IF((($H$1:$H$1000<=-24)+($H$2:$H$1000="#")+($I$1:$I$1000<=-24)+($L$1:$L$1000<=-24)+($L$2:$L$1000="#")+($O$1:$O$1000<=-24)),1,0))," ")

You don't need the range 1:1000 just the row as per formula in #17.

Your formula does not count #VALUE errors: if you want them counted change the IFERROR(......., 1)

If I don't put 1:1000 it returns a value of 1 for every row.

=IFERROR(SUM(IF(($H2<=-24)+($I2<=-24)+($L2<=-24)+($O2<=-24)+($H2="#")+($I2="#")+($L2="#")+($O2="#"),1,0)),1)

Works OK for me!

You are correct it works now. thanks.