Hello Will,

Currently SUMIFS is not supported as it is not part of the OpenFormula standard, but I have put in a feature request to support the formula in a future release. For now, the following JavaScript should suffice, just a minor tweak to the existing code:

$(document).ready(function () {
  $('.cf-table-block').on('blur','input',sumtotal);
  $('.tax').on('blur','input',sumtotal);
  $('.shipping').on('blur','input',sumtotal);
  function sumtotal() {
    var sum = 0;
    $('.cf-table-block tbody tr').each(function () {
      var s = 0;
      s = parseNumber($(this).find('.price input').val()) * parseNumber($(this).find('.quantity input').val());
      $(this).find('.subtotal input').val(s);
      if (($(this).find('.department select').val() == "Admin")
         && ($(this).find('.id input').val() == "7196")) {
      	sum += s;
      }
    });
    $('.total input').val(sum);
  }
  function parseNumber(n) {
    var f = parseFloat(n);
    return isNaN(f) ? 0: f;
  }
});

Note that to use this code as-is, you must set the GL Account ID to have the class "id" (which admittedly is probably not the best name given CSS terminology...) in order to check its value.

Hope this helps!