T
Tom Ulincy
Can a conditional formula be used to sum or count values
across multiple worksheets?
across multiple worksheets?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
Tom Ogilvy
How many conditions? Array formulas don't generally work across multiple
sheets.
Are you talking about with Code or using worksheet formulas in a cell?
sheets.
Are you talking about with Code or using worksheet formulas in a cell?
T
Tom Ulincy
One condition is all I need to test (e.g. count where
value = "Yes"). My first preference was to do it with
worksheet formulas but a UDF is acceptable.
Tom
value = "Yes"). My first preference was to do it with
worksheet formulas but a UDF is acceptable.
Tom
T
Tom Ogilvy
=SUM(COUNTIF(INDIRECT({"Sheet1","Sheet2","Sheet3"} &"!A:A"),"yes"))
or
=SUM(COUNTIF(INDIRECT( "Sheet" &{1,2,3} &"!A:A"),"yes"))
counts the cells in 3 sheets that have yes in column A as an example.
This is not an array formula. (it doesn't need to be array entered). That
may not be true for any formula of this type that you come up with, so if
you don't get expected results, try entering it as an Array formula.
or
=SUM(COUNTIF(INDIRECT( "Sheet" &{1,2,3} &"!A:A"),"yes"))
counts the cells in 3 sheets that have yes in column A as an example.
This is not an array formula. (it doesn't need to be array entered). That
may not be true for any formula of this type that you come up with, so if
you don't get expected results, try entering it as an Array formula.