Excel Peeps...
Pic Whore
Joined: Jul 2004
Posts: 22,224
Likes: 1
From: NJ
Originally Posted by Tark
I LOVE YOU 
h: it worked... only thing was the language cause i am working with a french Ver.
Meyb one more question how do you use the count function? cause in a different column their is the kind of memebership. So platnum, gold, silver bronze. I would like a cell to give me amount of platnium. other cell for gold, other for.... you know what i mean.
h: it worked... only thing was the language cause i am working with a french Ver.Meyb one more question how do you use the count function? cause in a different column their is the kind of memebership. So platnum, gold, silver bronze. I would like a cell to give me amount of platnium. other cell for gold, other for.... you know what i mean.
=SUM(IF(RANGE="platinum",1,0)) and Ctrl+Shift+Enter
Thread Starter
Senior Member
Joined: Jun 2004
Posts: 30,331
Likes: 0
From: Montréal, Canada
Originally Posted by janiVI
try
=SUM(IF(RANGE="platinum",1,0)) and Ctrl+Shift+Enter
=SUM(IF(RANGE="platinum",1,0)) and Ctrl+Shift+Enter
here is what i tried:
=Sum(IF(AND('Consolidation des rapports'!L5:L347="Platinum";YEAR('Consolidation des rapports'!J5:J10000)=2003);1;0))
ctrl+shift+enter
and it gives me 0
Thread Starter
Senior Member
Joined: Jun 2004
Posts: 30,331
Likes: 0
From: Montréal, Canada
Originally Posted by jclau00
try this...
=SUM(IF(A1:A4=2005,1,0)*IF(B1:B4="bronze",1,0)) then ctrl shft enter
the logic behind this is if both conditions are true, then 1 * 1 = 1 else it'll be = 0
=SUM(IF(A1:A4=2005,1,0)*IF(B1:B4="bronze",1,0)) then ctrl shft enter
the logic behind this is if both conditions are true, then 1 * 1 = 1 else it'll be = 0
:wtc:
Senior Member
Joined: Sep 2002
Posts: 1,104
Likes: 0
From: bay area, cali
Originally Posted by Tark
but that wouldnt count anything. The final anser would be 1 or 0 right?
:wtc:
:wtc:
Thread Starter
Senior Member
Joined: Jun 2004
Posts: 30,331
Likes: 0
From: Montréal, Canada
Originally Posted by jclau00
no, it'll work. the reason you have to do the ctrl shft enter to make the {} is because it's an array. it'll perform that function on the entire range. so in the end you'll get a bunch of 0s and 1s which will be summed for you conveniently in a single cell.