Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIFS question | Excel Worksheet Functions | |||
IF formula-simple question; simple operator | Excel Discussion (Misc queries) | |||
Excel CountIfs() and SumIfs() question | Excel Worksheet Functions | |||
Simple Simple Excel usage question | Excel Discussion (Misc queries) | |||
simple question, hopefully a simple answer! | Excel Programming |