| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
best way to count something in one column using criteria in another column
Hi
I would like to know the best way to count the number of cells that have Pass in one column but only covering those in week 20 in another column A B 19 Pass 19 Pass 19 Fail 19 Pass 20 Pass 20 Fail 20 Pass 21 Fail 21 Pass Thank you very much Hj |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
best way to count something in one column using criteria in another column
Hi,
Am Wed, 23 May 2012 19:45:24 +0100 schrieb Hankjam: I would like to know the best way to count the number of cells that have Pass in one column but only covering those in week 20 in another column 19 Pass 19 Pass 19 Fail 19 Pass 20 Pass 20 Fail 20 Pass 21 Fail 21 Pass in versions < 2007: =SUMPRODUCT(--(A1:A100=20),--(B1:B100="Pass")) xl2007 or xl2010: =COUNTIFS(A:A,20,B:B,"Pass") Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
best way to count something in one column using criteria in another column
On Wed, 23 May 2012 20:58:13 +0200, Claus Busch
wrote: =SUMPRODUCT(--(A1:A100=20),--(B1:B100="Pass")) Hi Claus Works a treat, many thanks Hj |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count how many criteria in a column match criteria in another colu | Excel Discussion (Misc queries) | |||
| Based on Mulipple Criteria acrossed Column count last column | Excel Worksheet Functions | |||
| Count with multiple column criteria | Excel Discussion (Misc queries) | |||
| How do I count in column A when it meets all criteria in three col | Excel Worksheet Functions | |||
| Can I count values in column 1 if criteria in column 2 are met | Excel Worksheet Functions | |||
![Hankjam[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
