simple sumIfs question
 

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

simple sumIfs question
 

Add them individually. Note the code below Adds "A1" twice

Set RowHeader = Rows(1)
Set ColHeader = Columns(1)
Total = 0
Total = WorksheetFunction.SumIf(RowHeader, "1")
Total = Total + WorksheetFunction.SumIf(ColHeader, "1")

"Cresta" wrote:

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