Does sumifs criteria only work if the ranges are parallel, for example only
columns or only rows. Or can it have mixed criteria ranges, like a row across
the top of a table and a column down the left, returning the intersection
cell value.

Thanks