B
Bones
Im trying to use a formula that uses multiple functions,. "sumif" and "and",
but i dont think i am using the "and" correctly becuase it is giving wrong
results. Please explain...
=SUMIF(A2:A701, A2, J2:J701)*AND(C$2:C$701<>39753,39783)
The and part is also using dates that are turned into numbers. The results
are not recognizing that part of the formula after the and
but i dont think i am using the "and" correctly becuase it is giving wrong
results. Please explain...
=SUMIF(A2:A701, A2, J2:J701)*AND(C$2:C$701<>39753,39783)
The and part is also using dates that are turned into numbers. The results
are not recognizing that part of the formula after the and