Home |
Search |
Today's Posts |
#1
|
|||
|
|||
COUNT INFORMATION IN COLUMN B ONLY IF A1 MATCHES K1 COUNT THAT CE.
i'm trying to count the cell information that's in column b but only if
columns a and k equal each other. |
#2
|
|||
|
|||
One way:
=SUMPRODUCT(--(A1:A1000=K1:K1000),B1:B1000) For an explanation of the "--" see http://www.mcgimpsey.com/excel/doubleneg.html In article , "witchcat98" wrote: i'm trying to count the cell information that's in column b but only if columns a and k equal each other. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count the text in a column - Part II | Excel Discussion (Misc queries) | |||
How do I count the amount of text in a column and then add them | Excel Discussion (Misc queries) | |||
How do I count or display unique data in a column? | Excel Worksheet Functions | |||
Can I count values in column 1 if criteria in column 2 are met | Excel Worksheet Functions | |||
Count rows based on multiple criteria | Excel Worksheet Functions |