Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formula
Can a conditional formula be used to sum or count values
across multiple worksheets? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formula | Excel Worksheet Functions | |||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
Formula, Conditional Formula Needed | Excel Discussion (Misc queries) | |||
Conditional Formula to indicate Formula in cell | New Users to Excel | |||
Conditional Sum Formula | Excel Discussion (Misc queries) |