Hello Excel "Gurus"
I'm trying a formula but I really don't kown where is the mistake
You will see in Attachment my expected result
Because i'm Able to count in differnt sheets with 1 criteria, but now my probem is to count in dynamic sheets
that means for example: to count only from March till August or count febraury till april
I hope is clear
Thank yu for your help
This formula is not completed
=INDIRECT(ADDRESS(MATCH(B2,I:I,0),9)&":"&ADDRESS(MATCH(B3,I:I,0),9))
I found this elsewhere and learned something. COUNTIF will not work across multiple sheets. However, there is a trick you can do with SUMPRODUCT and COUNTIF: =SUMPRODUCT(COUNTIF(INDIRECT(MonthRange&"!F2:F100"),D2))
MonthRange is a named range defined as: =OFFSET(Summary!$I$1,Summary!$C$2,0,Summary!$C$3-Summary!$C$2+1,1)
You will note that I have two helper cells In column C that find where the start month and end month are found in the list of months. So as shown in the example, this is the range I4:I6.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
wooowww!! dflack
Excellent Job!!!!!
Better later than never
I liked the way yu used the OFFSET inside the define name
Thank so much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks