| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do you make a countif formula with 2 or more critera?
..
|
|
#2
|
|||
|
|||
|
Melissa, try this, will count the number that meet test, for, and 3 in
columns A, B, and C, 2:25 =SUMPRODUCT((A2:A25="test")*(B2:B25="For")*(C2:C25 =3)) -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Melissa" wrote in message ... . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Easy countif formula | Excel Discussion (Misc queries) | |||
| Formula Help "Let me know if I do not make sence". | Excel Discussion (Misc queries) | |||
| Creating an EXCEL COUNTIF formula for a range of values | Excel Discussion (Misc queries) | |||
| Formula to make Excel count business days/skip weekends? | Excel Worksheet Functions | |||
| How do I make a formula for precentages? | Excel Worksheet Functions | |||
Linear Mode
