| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Excel function to countif a criteria is matced within to columns
Hello, I am looking for a the proper function in excel that would allow me to
count if a criteria is matched in column "A" and if another criteria is matched in column "B". |
|
#2
|
|||
|
|||
|
You are looking at SUMPRODUCT, but not on whole columns, just part
=SUMPRODUCT(--(A1:A100="val1"),--(B1:B1000=123)) -- HTH RP (remove nothere from the email address if mailing direct) "=countif(data!A:A, 001 ,andif (data!B:B," <=countif(data!A:A,"001",andif wrote in message ... Hello, I am looking for a the proper function in excel that would allow me to count if a criteria is matched in column "A" and if another criteria is matched in column "B". |
|
#3
|
|||
|
|||
|
SUMPRODUCT(--(A:A="criteria1"),--(A:A="criteria2")) =countif(data!A:A,"001",andif (data!B:B, Wrote: Hello, I am looking for a the proper function in excel that would allow me to count if a criteria is matched in column "A" and if another criteria is matched in column "B". -- Morrigan ------------------------------------------------------------------------ Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094 View this thread: http://www.excelforum.com/showthread...hreadid=399170 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using ADD function within DCOUNT criteria | Excel Discussion (Misc queries) | |||
| Could the "Criteria" in COUNTIF function be a cell reference? | Excel Worksheet Functions | |||
| How do I create a COUNTIF function with more than one criteria? | Excel Worksheet Functions | |||
| Countif Function -Nested | Excel Discussion (Misc queries) | |||
| Statistical Excel Function Question within Excel 2000... | Excel Worksheet Functions | |||
Hybrid Mode
