| COUNTIF across multiple sheets | jkendra | 7/1/12 1:17 PM | I have a spreadsheet I am using as a specialized work calendar. Each sheet is a one week date range. I typically have 6 weeks (sheets) per worksheet. Each sheet is of the same format. Each sheet is named for its week, ie., "June 24-30" The last s |
| Re: COUNTIF across multiple sheets | Yogi Anand | 7/1/12 3:18 PM | Hi jkendra: one way would be to use the VMERGE custom written function by ahab (available in Script gallery from within a spreadsheet) to merge the data from various weeks into the summary sheet -- then you can use a function such as FILTER or QUERY |
| Re: COUNTIF across multiple sheets | jkendra | 7/1/12 7:50 PM | Yogi, If you could show example of script that would be great! Maybe after looking at example spreadsheet you may have another idea... Example spreadsheet has different data than that referenced to in my initial post but idea is same. https://docs. |
| Re: COUNTIF across multiple sheets | Yogi Anand | 7/2/12 11:25 AM | Hi jkendra: I have posted a solution in my following blog post ... yogi_Count Number Of Employees At A Specified Location From Data In Multiple Sheets http://yogi--anand-consulting.blogspot.com/2012/07/yogicount-number-of-employees-at.html Please |
| Re: COUNTIF across multiple sheets | jkendra | 7/2/12 4:16 PM | Thanks for your help, but I am currently using:=countif('July 2-8'!C$6:G$6;A4)+countif('July 9-15'!C$6:G$6;A4)+countif('July 16-22'!C$6:G$6;A4) which essentially does the same thing. What I would like to do is either1- optimally not have to includ |
| Re: COUNTIF across multiple sheets | APL+ | 7/2/12 5:32 PM | +jkendra, there really is no "easy" solution for this. The problem with custom functions (like the ThreeDim function you've attempted) is that they will not automatically recalculate with each edit, unless the values that are being processed are bei |