simple sumIfs question

  • Thread starter Thread starter Cresta
  • Start date Start date
C

Cresta

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
 
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")
 
Back
Top