SUMIF function - multiple criteria

  • Thread starter Thread starter VERONICA
  • Start date Start date
V

VERONICA

I'm trying to provide two criteria in this function to be
true but it only seems like it will allow only one
criteria to be defined. I also need the criteria to show
the following:

"<>7P5D and <>7P5N"

This is the way Excel will accept the function:
=SUMIF(A2:A10,"<>7P5D",D2:D10)
 
Back
Top