Countif with multiple criteria and multiple worksheets
I have a workbook that has 7 worksheets. In one of the worksheets, I have to
total the numbers from the other 6 worksheets dependent on certain information: Where ID=RM (which is column C7 in the primary worksheet -- which is what I would like to use to make it a variable value versus a constant value with the RM) AND $L:$L (from the other worksheet) = Submitted AND $G:$G (from the other worksheet) = A I have tried using: =COUNT(('[David Artifacts (All PAs).xls] Artifacts'!$B$2:$B$971,C7) * ('[David Artifacts (All PAs).xls] Artifacts'!$L:$L,"Submitted") * ('[David Artifacts (All PAs).xls] Artifacts'!$G:$G,"A")) But this does not work. The total for =COUNTIF('[David Artifacts (All PAs).xls] Artifacts'!$B$2:$B$971,C7) is 34. Is there a way that I can achieve this? Thank you, JJ |
I forgot to mention that each worksheet will be added in a separate column,
so I will only need to work with 1 worksheet at a time off of the primary worksheet. Thank you. "JJ" wrote: I have a workbook that has 7 worksheets. In one of the worksheets, I have to total the numbers from the other 6 worksheets dependent on certain information: Where ID=RM (which is column C7 in the primary worksheet -- which is what I would like to use to make it a variable value versus a constant value with the RM) AND $L:$L (from the other worksheet) = Submitted AND $G:$G (from the other worksheet) = A I have tried using: =COUNT(('[David Artifacts (All PAs).xls] Artifacts'!$B$2:$B$971,C7) * ('[David Artifacts (All PAs).xls] Artifacts'!$L:$L,"Submitted") * ('[David Artifacts (All PAs).xls] Artifacts'!$G:$G,"A")) But this does not work. The total for =COUNTIF('[David Artifacts (All PAs).xls] Artifacts'!$B$2:$B$971,C7) is 34. Is there a way that I can achieve this? Thank you, JJ |
All times are GMT +1. The time now is 12:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com