Hi,
I am trying to get the two formulas to work below. Basically for the first one I am trying to take the stdev of all the values in column Q that have the data in column J values listed are = "1", as well as the value in O being >19 as well as <39. If J=1, and O>19 as well as O<39, I would like it to take the stdev of all the values that fit the criteria in row Q.
The second one is very similar, except I want to sum the values if they meet the criteria.
=STDEV(IF((J2:J6357="1")+(O2:O6357>="19")+(O2:O6357<="39"),Q2:Q6357))
=SUMIF(J2:J6357,(J2:J6357="1")+(O2:O6357>="19")+(O2:O6357<="39"),Q2:Q6357))
Thank you so much for your help
Bookmarks