Conditional Formula
 

Can a conditional formula be used to sum or count values
across multiple worksheets?

Conditional Formula
 

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?

--
Regards,
Tom Ogilvy


"Tom Ulincy" wrote in message
...
Can a conditional formula be used to sum or count values
across multiple worksheets?

Conditional Formula
 

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



-----Original Message-----
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?

--
Regards,
Tom Ogilvy


"Tom Ulincy" wrote
in message
...
Can a conditional formula be used to sum or count values
across multiple worksheets?


.

Conditional Formula
 

=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.


--
Regards,
Tom Ogilvy

"Tom Ulincy" wrote in message
...
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



-----Original Message-----
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?

--
Regards,
Tom Ogilvy


"Tom Ulincy" wrote
in message
...
Can a conditional formula be used to sum or count values
across multiple worksheets?


.