Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 28th 04, 07:33 PM
JJ
 
Posts: n/a
Default 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




  #2   Report Post  
Old December 28th 04, 07:37 PM
JJ
 
Posts: n/a
Default

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





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sum using multiple criteria Barbara 1 Excel Worksheet Functions 4 December 3rd 04 10:07 PM
How do I ask for multiple criteria when creating a "sumif" formul. Rachelle Excel Worksheet Functions 3 December 2nd 04 12:49 AM
Counting "rows", i.e. simultaneous criteria for multiple cells gkline Excel Worksheet Functions 2 November 19th 04 08:30 AM
calculate percent from multiple criteria Jan Excel Worksheet Functions 0 November 10th 04 07:09 PM
Count rows based on multiple criteria Murph Excel Worksheet Functions 1 October 28th 04 07:13 AM


All times are GMT +1. The time now is 02:34 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017