Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced count function
Lets say my data looks like this:
A B 5 Travis 4 Travis 3 Nick 2 Travis 1 Don 9 Mike How do I make a count function that looks at that and the logic is: If A is less than 4 and B equals Travis And just to clearify that I understand if I get an answer, how would I do: If A is greater than 2 and A less than 15 and B equals Travis To verify, I want the number returned of how many results there are. Thank you for looking, and for your help/time. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced count function
Forgot to say, this is Excel 2003.
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced count function
Eric wrote...
Lets say my data looks like this: A B 5 Travis 4 Travis 3 Nick 2 Travis 1 Don 9 Mike How do I make a count function that looks at that and the logic is: If A is less than 4 and B equals Travis =SUMPRODUCT((A2:A7<4)*(B2:B7="Travis")) And just to clearify that I understand if I get an answer, how would I do: If A is greater than 2 and A less than 15 and B equals Travis .... =SUMPRODUCT((A2:A72)*(A2:A7<15)*(B2:B7="Travis")) |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced count function
First one:
=SUMPRODUCT(--(A2:A10<4),--(B2:B10="Travis")) Second one: =SUMPRODUCT(--(A2:A102),--(A2:A10<15),--(B2:B10="Travis")) HTH, Paul "Eric" wrote in message ... Lets say my data looks like this: A B 5 Travis 4 Travis 3 Nick 2 Travis 1 Don 9 Mike How do I make a count function that looks at that and the logic is: If A is less than 4 and B equals Travis And just to clearify that I understand if I get an answer, how would I do: If A is greater than 2 and A less than 15 and B equals Travis To verify, I want the number returned of how many results there are. Thank you for looking, and for your help/time. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advanced Filters - 'or' function | Excel Discussion (Misc queries) | |||
Advanced text function | Excel Worksheet Functions | |||
Advanced IF function | Excel Worksheet Functions | |||
Advanced unique cell count with multiple conditions ... help! | Excel Worksheet Functions | |||
Advanced Count functions | Excel Discussion (Misc queries) |