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
|
|||
|
|||
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
|
|||
|
|||
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 |
#3
|
|||
|
|||
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". |
#4
|
|||
|
|||
You need to substitute "val1" and 123 with your values
-- HTH RP (remove nothere from the email address if mailing direct) "=countif(data!A:A, 001 ,andif (data!B:B," .com wrote in message ... Thanks for the quick response, but the formula =SUMPRODUCT(--(A1:A100="val1"),--(B1:B1000=123)) did not work. What I would like for the formula to do is count the number of occurences only if the criteria defined in column "a" and column "b" are met. I tried the formula you provided and it gave me #value!, it would not populate the total of occurences. I know how to have it count if I will looking for data within one column, I just can make it look different data within two column. The formula I was using for one column was =countif(Data!A:A,"002asm") "=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". |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Complex query criteria - desperate appeal | Ted Allen | Running & Setting Up Queries | 5 | November 17th, 2004 06:14 PM |
Pasting Access table into Excel; can't use SUM function | James Buehner | General Discussion | 3 | November 4th, 2004 11:50 PM |
Add-in functions when starting Excel programmatically | Steve K. | Worksheet Functions | 11 | July 2nd, 2004 06:38 PM |
Countif functions with multiple criteria | Jason Morin | Worksheet Functions | 3 | April 5th, 2004 08:46 PM |
Countif functions with multiple criteria | t | Worksheet Functions | 0 | April 5th, 2004 07:11 PM |