Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 09-04-2009
Member
 
Join Date: Jan 2009
Posts: 11
Excel: Using multiple criteria

I have been trying to do a little counting a lot of talk but little trouble finding the right function

The situation is as follows:

I have 3 columns.
The first column there are various names, Lasse, Jens, Soren
In the second column, there are different sports, eg football and handball
In the third column are listed a number of points he has made in that sport.
(a person can easily occur multiple times in each sport)

What I would like it to have to count all points along the criteria "Lasse" is included in column 1 and "football" is included in column 2

I have so far spent sum.hvis a lot of other things but can not find out whether it can help when multiple criteria must be met

Hope there is a helpful excel shark out there
Reply With Quote
  #2  
Old 09-04-2009
Member
 
Join Date: May 2008
Posts: 4,829
Re: Excel: Using multiple criteria

You should be able to create a pivot table of your data, and then structure the following columns 1 and 2 in rows and the sum of your score values.

otherwise you enter in something SUMIFS = () lark
= SUMIFS ([column with your point], [column with your name], [name you are searching for] "Lasse" (possibly cellular); [column with your sports], [name of your sport] "football" ( possible. cell))
Reply With Quote
  #3  
Old 09-04-2009
Member
 
Join Date: Jan 2009
Posts: 11
Re: Excel: Using multiple criteria

I have unfortunately not tracked PivotTable yet. Furthermore, I am using Excel 2002 in spanish as function sumifs () does not exist or I just cannot find the correct translation.
Reply With Quote
  #4  
Old 09-04-2009
Member
 
Join Date: May 2008
Posts: 4,829
Re: Excel: Using multiple criteria

you do not have a grip on the PivotTable to use them.
Select your 3 columns, go into paste and make a new pivot table.
So put your names into first, and so your sports in the left side.
Then take your points and apply into right.

In English it reads: "=sum.hviser()"
Reply With Quote
  #5  
Old 09-04-2009
Member
 
Join Date: Jan 2009
Posts: 11
Re: Excel: Using multiple criteria

Well I found out that I could use the following
SUMPRODUCT((A1:A60="Lasse")*(B1:B6
0="Fodbold")*C1:C60)

My thanks to those who have made proposals for the solution.

And then my job as to have upgraded their excel version.
Reply With Quote
  #6  
Old 09-04-2009
Member
 
Join Date: May 2008
Posts: 4,339
Re: Excel: Using multiple criteria

Quote:
Originally Posted by Quily View Post
And then my job as to have upgraded their excel version.
Yes for an English. It is completely ridiculous that function names are also translated. So the world with illiterate IT people can not do it.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags:



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Excel: Using multiple criteria"
Thread Thread Starter Forum Replies Last Post
Removing data from Microsoft Excel 2003 by setting criteria Rashid Windows Software 3 10-03-2012 08:00 PM
excel: delete (or find) cell if it meets certain criteria cmendes Windows Software 3 12-11-2011 12:14 PM
Based on Cell Criteria Delete Row in excel AlpAnA$ Windows Software 5 09-07-2011 08:50 PM
How to sum numbers with certain criteria in Excel Laalamani Windows Software 5 23-10-2010 02:31 PM
use multiple criteria in a INDEX/MATCH Formula Shekhar12 Windows Software 3 12-11-2009 03:24 PM


All times are GMT +5.5. The time now is 02:48 AM.