Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

It's hard to describe what I want, I'm not really familiar with Excel condition terms but it is basically just like this:

Worksheet= Dr. castro patient consultations

A        B     C      D       E
January  1     2014   Lopez   Sam



Worksheet= Patient Library

A        B     Jan      Feb       E
Lopez    Sam   =if 'Dr. castro patient consultations'!A1 = January then +1  

I know my question isn't very clear, but I really want to do this project to make our clinic's monthly assessment better. pls help me guys. thanks A LOT.

share|improve this question

closed as unclear what you're asking by Raystafarian, Tog, ultrasawblade, Mokubai, AthomSfere May 2 at 10:49

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question.If this question can be reworded to fit the rules in the help center, please edit the question.

    
I tried to edit your question, but I still don't understand the second worksheet. –  Raystafarian Mar 1 at 16:52
    
What is the question? Are you trying to summarize patient visits by month? –  andy holaday Mar 4 at 1:04
    
Is the issue that Conditional Formatting is not allowing a reference to a different sheet in the condition formula? –  Excellll May 1 at 14:10

2 Answers 2

Excel will not allow a bare reference to another sheet in a conditional formatting formula.

enter image description here

To get around this, you can create a Named Range to represent the data on the other sheet. Conditional formatting allows references to named ranges, even if they are found on a different sheet.

Create Named Range:

enter image description here

Use Named Range in Conditional Formatting Rule:

enter image description here

share|improve this answer

The question is unclear. I think you have a list of bookings in the first worksheet and want a formula that would give you the number of bookings that are in January with a particular doctor. If that's right, then the following formula would work:

=COUNTIFS('Dr. castro patient consultations'!A:A,"January",'Dr. castro patient consultations'!D:D,"Lopez",'Dr. castro patient consultations'!E:E,"Sam")
share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.