|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 27th, 2005, 07:35 PM
|
|||
|
|||
How do I count number of cels the matches 2 conditions ?
How do I count number of cels the matches 2 conditions (I am using COUNTIF
and AND) ??? I need the total of cels that matches the 2 conditions and not the sum of the cels. Thanks 
|
|
#2
February 27th, 2005, 07:45 PM
|
|||
|
|||
|
=SUMPRODUCT(--(A1:A100="value1"),--(A1:A100="value2"))
-- HTH RP (remove nothere from the email address if mailing direct) "Abra" wrote in message ... How do I count number of cels the matches 2 conditions (I am using COUNTIF and AND) ??? I need the total of cels that matches the 2 conditions and not the sum of the cels. Thanks
|
|
#3
February 27th, 2005, 08:56 PM
|
|||
|
|||
|
You could use Countif() in conjunction with Sum() to count against any
number of conditions: =SUM(COUNTIF(A1:A100,{"cond#1","cond#2","cond#3"}) ) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Abra" wrote in message ... How do I count number of cels the matches 2 conditions (I am using COUNTIF and AND) ??? I need the total of cels that matches the 2 conditions and not the sum of the cels. Thanks
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Pivot Table Access 2000? | Air-ron | General Discussion | 2 | October 29th, 2004 06:19 PM |
| Count and display the Number of "Yes" in various fields | ehale | Setting Up & Running Reports | 6 | September 30th, 2004 04:47 PM |
| auto number and count cells not values within the cells | Judi J | Worksheet Functions | 5 | August 27th, 2004 05:40 AM |
Linear Mode
