| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
help with a formulae
Hi, Can I use If function with two diff criteria... I have a recruiter column
and offered column. I want the count of how many each recruiter has done.. eg: countif(A1:a6,"abc" then give me count of offered from abc... Ids this possible.. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
help with a formulae
Use a formula like:
=SUMPRODUCT((A1:A10="A")*(B1:B10="B") which will count the number of entries where there is an A in A1:A10 AND a B in B1:B10. Change A and B with your desired criteria. -- Thanx in advance, Best Regards, Faraz "Nemo" wrote: Hi, Can I use If function with two diff criteria... I have a recruiter column and offered column. I want the count of how many each recruiter has done.. eg: countif(A1:a6,"abc" then give me count of offered from abc... Ids this possible.. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
help with a formulae
Sorry add a closing bracket like:
=SUMPRODUCT((A1:A10="A")*(B1:B10="B")) You may insert as many similar subsets u want. Like =SUMPRODUCT((A1:A10="A")*(B1:B10="B")*(C1:C10="C") *(D1:D10="D")) -- Thanx in advance, Best Regards, Faraz "Faraz A. Qureshi" wrote: Use a formula like: =SUMPRODUCT((A1:A10="A")*(B1:B10="B") which will count the number of entries where there is an A in A1:A10 AND a B in B1:B10. Change A and B with your desired criteria. -- Thanx in advance, Best Regards, Faraz "Nemo" wrote: Hi, Can I use If function with two diff criteria... I have a recruiter column and offered column. I want the count of how many each recruiter has done.. eg: countif(A1:a6,"abc" then give me count of offered from abc... Ids this possible.. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using two formulae | Excel Worksheet Functions | |||
| Formulae: Paste value formulae after doing an average operation | Excel Discussion (Misc queries) | |||
| formulae | Excel Discussion (Misc queries) | |||
| Help with formulae | New Users to Excel | |||
| Searching TEXT in formulae, rather than results of formulae | Excel Worksheet Functions | |||
Linear Mode
