How do i use "and" in a formula

  • Thread starter Thread starter Bones
  • Start date Start date
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
 
=SUMIF(A2:A701, A2, J2:J701)*AND(C$2:C$701<>39753,39783)

This should do the logics and calcs that you seek above
=SUMPRODUCT((A$2:A$701=A2)*(ISERROR(MATCH(C$2:C$701,{39753,39783},0))),J$2:J$701)
Copy down as may be desired

If it helped, do high-five this response by pressing the YES button below

p/s: Do post such queries in excel.worksheet.functions, which is a more
appropriate and better attended newsgroup
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
 
Back
Top