Conditional Formula

  • Thread starter Thread starter Tom Ulincy
  • Start date Start date
T

Tom Ulincy

Can a conditional formula be used to sum or count values
across multiple worksheets?
 
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?
 
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
 
=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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting with VBA 4
Excel VBA 1
Help needed 0
Conditional Formatting 1
IF(AND(Complex Formula in Error in data import before I process it 8
Excel Highlighting duplicates 0
Conditional formating not working 5
Sumif with multiple conditions 3

Back
Top