Array across multiple worksheets
I have a situation where I am attempting to summarize how many times a value
in a cell occurs across multiple worksheets within the same range on each. The problem that I have is that I need to limit the search based on the current week that I am working with. The worksheets are labeled "Week1","Week2", etc. Here is the formula that I am attempting to use which isn't working: =SUM(COUNTIF(INDIRECT("Week"&ROW(INDIRECT("1:"&B8) )&"!B84:B89"),D13)) where the value in B8 is 3 and the value in D13 is 4 Thanks in advance RDA |
Array across multiple worksheets
What is the issue, it works if you array-enter it.
If you don't want to array-enter, use =SUMPRODUCT(COUNTIF(INDIRECT("Week"&ROW(INDIRECT(" 1:"&B8))&"!B84:B89"),D13)) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "rda" wrote in message ... I have a situation where I am attempting to summarize how many times a value in a cell occurs across multiple worksheets within the same range on each. The problem that I have is that I need to limit the search based on the current week that I am working with. The worksheets are labeled "Week1","Week2", etc. Here is the formula that I am attempting to use which isn't working: =SUM(COUNTIF(INDIRECT("Week"&ROW(INDIRECT("1:"&B8) )&"!B84:B89"),D13)) where the value in B8 is 3 and the value in D13 is 4 Thanks in advance RDA |
All times are GMT +1. The time now is 05:42 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com