I have a spreadsheet from my employer that lists in the "Quantity" column several types of numbers representing in the "Type" column things like "DeadMiles", "PerMile", "Commins", "CellPh", etc. I need to add up all the "DeadMiles" and "PerMile" quantities. I thought the SUMIF functions would do it with J5:J1483 being the range of the "Type" column and H5:H1483 being the range of the "Quantity" column. I figured I would enter "DeadMile" and "PerMile" in two separate SUMIF's and then add them together. So here is my first attempt at the DeadMiles:

=SUMIF(J5:J1483,"Type"=ISTEXT("DeadMile"),H5:H1483)

I keep getting 0 returned by this function. Where's my mistake?

Any suggestions are much appreciated.