HELP! SUM formula

[MW012]

Okay, so I have this spreadsheet set up, I only want it to count if all four of the cells read true. so I have this set up. This continues on through G202. Here is my problem, whenever only G7,8,9, and 10 are true it is giving me a total of 2 instead of just 1. It does the same with G11,12,13,and 14. Why is it counting these as 2 instead of 1 as I indicated?

What is going on is I am checking the weather at different intervals of a flight so I have a true false system set up. I only want it to count that flight when all four intervals read true.


=SUM(IF(AND(G3=TRUE,G4=TRUE,G5=TRUE,G6=TRUE),1,0),(IF(AND(G7=TRUE,G8=TRUE,G9=TRUE,G10=TRUE),1,0)),(IF(AND(G11=TRUE,G12=TRUE,G13=TRUE,G14=TRUE),1,0)),(IF(AND(G7=TRUE,G8=TRUE,G9=TRUE,G10=TRUE),1,0)),(IF(AND(G11=TRUE,G12=TRUE,G13=TRUE,G14=TRUE),1,0)),(IF(AND(G15=TRUE,G16=TRUE,G17=TRUE,G18=TRUE),1,0)))

 

[Jonmo1]

You have this in there twice
IF(AND(G7=TRUE,G8=TRUE,G9=TRUE,G10=TRUE),1,0)

Same for
IF(AND(G11=TRUE,G12=TRUE,G13=TRUE,G14=TRUE ),1,0)

 

[MW012]

You have this in there twice
IF(AND(G7=TRUE,G8=TRUE,G9=TRUE,G10=TRUE),1,0)

Same for
IF(AND(G11=TRUE,G12=TRUE,G13=TRUE,G14=TRUE ),1,0)

Hahahaha oh wow! Sometimes you just get so sucked in you do not notice dumb errors like that! Thank you.

 

[Jonmo1]

Glad to help, thanks for the feedback.

 

[MW012]

Okay so new question with this set up. Instead of counting "1" when all four = "TRUE," I would like it to count "1" if any combination of the four cells = "TRUE." So if two of the four cells = "TRUE" it would count "1" or if one of the four cells = "TRUE" it would count "1" etc.

 

[Jonmo1]

Change the AND's to OR's

 

[MW012]

NEVERMIND. I believe I would just replace AND with OR