In column B, I have either a "F" or a "M". In column D, I have an "X" to denote an advanced row. I would like to count the number of X's in for the "F" rows. How do I write the if statement to count this.
Results 1 to 3 of 3
Thread: Count IF statement (Excel 2000)
-
New Lounger
- Join Date
- Nov 2001
- Posts
- 20
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2003-05-08 12:28Count IF statement (Excel 2000)
-
Subscribe to get a FREE chapter from Windows 7 The Missing Manual
This month, every Windows Secrets subscriber can download a one-chapter excerpt of Windows 7: The Missing Manual.Windows 7: The Missing Manual provides valuable information to help you overcome these difficulties in learning a new operating system. Subscribe today to download your free excerpt.
-
WS Lounge VIP
- Join Date
- Jul 2002
- Location
- Pittsburgh, Pennsylvania, USA
- Posts
- 10,167
- Thanks
- 8
- Thanked 159 Times in 154 Posts
2003-05-08 12:35Re: Count IF statement (Excel 2000)
Array formula (confirm with ctrl-shift-enter)
=COUNT(IF((D1
1000="X")*(B1:B1000="F"),1))
Change ranges as appropriate. (NOTE: you can NOT use the entire column in ARRAY formulas)
Steve
-
2 Star Lounger
- Join Date
- Jan 2002
- Location
- Tampico, Tamps, Mexico
- Posts
- 118
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2003-05-08 13:10Re: Count IF statement (Excel 2000)
This is a simple formula, is not array:
=SUMPRODUCT((B1:B1000="F")*(D11000="X")*1)
