Ask Experts Questions for FREE Help!
  Advanced
Register  |  Log in  
   Ask    
 Answer  
  Help  

Ask QuestionsprogressAnswer QuestionsprogressBuild ReputationprogressBecome an Expert
 
Free Answers in 3 Easy Steps

Register Now		 3 Steps

At Ask Me Help Desk you can ask questions in any topic and have them answered for free by our experts. To ask questions or participate in answering them you must register for a free account. By registering you will be able to:
  • Get free answers from experts in any of our 300+ topics.
  • Accept money for answers that you provide.
  • Communicate privately with other members (PM).
  • See fewer ads.

Home > Computers & Technology > Software > Spreadsheets   »   Counting when there are 2 criteria

Answer this Question Ask about Spreadsheets
 
Thread Tools Display Modes
Question
 
 
#1  
Old Mar 11, 2008, 09:11 AM
TamaraNewcombe
New Member
TamaraNewcombe is offline 		 
Join Date: Mar 2008
Posts: 2
TamaraNewcombe See this member's comment history on his/her Profile page.
Counting when there are 2 criteria
In a spreadsheet, how do I get a count total if there are two criteria? For example, in one column I want to count all the "1"'s if, in another column there is a "c".

Reply With Quote
 
     

Answers
 
 
Old Mar 11, 2008, 09:13 AM   #2  
Computer Expert
ScottGem is offline
 
ScottGem's Avatar
 
Join Date: Jan 2003
Location: LI, NY - USA
Posts: 23,698
ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.
Pay to call ScottGem for advice ($.75/min)
Call ScottGem via Skype™
Read up in Excel Help on Microsoft Query. You can use ths feature to do more complex queries of your data.
  Reply With Quote
 
     
Answer this Question Ask about Spreadsheets

« Previous Thread | Next Thread »

Thread Tools
Display Modes
Linear Mode Linear Mode

 
Similar Sponsors

Similar Threads
Question Asker Forum Answers Last Post
Counting Items Amyunimus Spreadsheets 1 Dec 9, 2007 06:44 PM
Counting technique moonsky Math & Sciences 1 Sep 24, 2007 07:17 AM
counting blank cells with multiple criteria jmaivang Spreadsheets 1 Jun 22, 2007 04:44 AM
Counting to a million shlm2u Mathematics 1 Dec 6, 2006 06:44 PM
Counting Cells If several criteria are true Amyunimus Spreadsheets 1 Jun 27, 2006 12:35 AM




Copyright ©2003 - 2007, Ask Me Help Desk.
All times are GMT -8. The time now is 08:13 PM.