Turtle34Copper ContributorMar 12, 2020Formula I am trying to do multiple formula and I want to make sure that I have the correct information in the formula. in column p i need to have it by state from a-z but also need to have it use column o f...Show MoreBook1.xlsx17 KB
TwifooSilver ContributorMar 12, 2020Turtle34 Perhaps, your COUNTIFS formula in P5 should be like this: =COUNTIFS(C$5:C$28,"<="&C5,O$5:O$28,">="&O5)For your reference, I hereto attached your file with the foregoing formula, copied down Column P. CountifsTwoCriteria.xlsx16 KB
