I wrote a formula to compare the individual values of cells B3:N3 against a fixed criteria of 2 and then against the individual values of cells B4:N4, if it's greater or equal to either, it should be counted.
=COUNTIF(B3,">=2")+AND(OR(B3>=B4,1,0))*COUNTIF(C3,">=2")+AND(OR(C3>=C4,1,0))
*COUNTIF(D3,">=2")+AND(OR(D3>=D4,1,0))*COUNTIF(E3,">=2")+AND(OR(E3>=E4,1,0))
*COUNTIF(F3,">=2")+AND(OR(F3>=F4,1,0))*COUNTIF(G3,">=2")+AND(OR(G3>=G4,1,0))
*COUNTIF(H3,">=2")+AND(OR(H3>=H4,1,0))*COUNTIF(I3,">=2")+AND(OR(I3>=I4,1,0))
*COUNTIF(J3,">=2")+AND(OR(J3>=J4,1,0))*COUNTIF(K3,">=2")+AND(OR(K3>=K4,1,0))
*COUNTIF(L3,">=2")+AND(OR(L3>=L4,1,0))*COUNTIF(M3,">=2")+AND(OR(M3>=M4,1,0))
*COUNTIF(N3,">=2")+AND(OR(N3>=N4,1,0))
I thought it was working, but when the next cell's grouping of data imported, it no longer returned the correct sum.
2.07 1.68 1.40 1.77 1.22
3.00 2.00 1.60 1.30 1.20
# of weeks standard met 2 out of 5
weeks 1,4 and 5 should have met the criteria, but currently only reflects 2 ...
Thank you in advance for the much needed assistance!![]()
Bookmarks