Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Which formula to use? countif, sumif, sumproduct
I would like to count the number of records that appear in the same column
for example column "A" A hat and coat coat hat hat and coat gloves The formula that i am looking for would answer the question, how many records contain ("hat and coat" and "hat") the answer would be 3 records. Any help would be greatly appreciated! -- Cheers |
#2
|
|||
|
|||
=SUMIF(A:A,"*hat*")
-- HTH RP (remove nothere from the email address if mailing direct) "zubee" wrote in message ... I would like to count the number of records that appear in the same column for example column "A" A hat and coat coat hat hat and coat gloves The formula that i am looking for would answer the question, how many records contain ("hat and coat" and "hat") the answer would be 3 records. Any help would be greatly appreciated! -- Cheers |
#3
|
|||
|
|||
=COUNTIF(Your_Range,"hat and coat")+COUNTIF(Your_Range,"hat")
or =SUMPRODUCT((Your_Range="hat and coat")+(Your_Range="hat")) -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------*------------------------------*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------*------------------------------*---------------- "zubee" wrote in message ... I would like to count the number of records that appear in the same column for example column "A" A hat and coat coat hat hat and coat gloves The formula that i am looking for would answer the question, how many records contain ("hat and coat" and "hat") the answer would be 3 records. Any help would be greatly appreciated! -- Cheers |
#4
|
|||
|
|||
meant COUNTIF
-- HTH RP (remove nothere from the email address if mailing direct) "Bob Phillips" wrote in message ... =SUMIF(A:A,"*hat*") -- HTH RP (remove nothere from the email address if mailing direct) "zubee" wrote in message ... I would like to count the number of records that appear in the same column for example column "A" A hat and coat coat hat hat and coat gloves The formula that i am looking for would answer the question, how many records contain ("hat and coat" and "hat") the answer would be 3 records. Any help would be greatly appreciated! -- Cheers |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
problems with sumif and countif | Excel Discussion (Misc queries) | |||
{} SumIf and CountIf | Excel Worksheet Functions | |||
Modifyiing a SumIF Formula to look for "OLA* | Excel Worksheet Functions | |||
use a date range as criteria in a countif formula | Excel Worksheet Functions | |||
Sumif not Sumproduct | Excel Worksheet Functions |