If you are thinking of
ORing the two criteria “HNT” and “HNT Fuel”, I am very much afraid that is not possible:
OR doesn’t return anything of use to
COUNTIFS. However, the
SUMIF formulas will accept an array of criteria, outputting an array of results, which you can sum up.
The following formula gets rid of the repetition and is extensible to allow for more variants:
Note you do not need the
= when comparing a string literal for equality (there are gotchas as to cell data to string conversion when you use a cell reference, but not with literals).