Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNTIF help please
I'm tracking my sales. One column (I) has a dropdown for either "New" or "Used" and the other (J) has a dropdown for either "Car" or Truck. New Car New Car Used Truck Used Car New Truck Used Truck Used Car How can I make Excel Count the number of "Car" that are ALSO "New" I've tried some COUNTIF commands with an AND command in there. I may be way off, but I also could just have a ) in the wrong place. I need it to tell me that {New Cars=2}{New Trucks=1}..etc... I hope I explained this ? alright. Thanks for all your help. -- lherndo ------------------------------------------------------------------------ lherndo's Profile: http://www.excelforum.com/member.php...o&userid=15569 View this thread: http://www.excelforum.com/showthread...hreadid=530538 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNTIF help please
The New's and Used's are in one column and the Cars and Trucks are in a seperate column. I had them spaced properly while I was typing the the format didn't stay with it when I posted. -- lherndo ------------------------------------------------------------------------ lherndo's Profile: http://www.excelforum.com/member.php...o&userid=15569 View this thread: http://www.excelforum.com/showthread...hreadid=530538 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNTIF help please
=SUMPRODUCT(--(I2:I500="New"),--(J2:J500="Truck"))
replace the new and truck with cells where you type the data that way you don't have to edit the formula every time you change criteria for example =SUMPRODUCT(--(I2:I500=K2),--(J2:J500=L2)) -- Regards, Peo Sjoblom http://nwexcelsolutions.com "lherndo" wrote in message ... I'm tracking my sales. One column (I) has a dropdown for either "New" or "Used" and the other (J) has a dropdown for either "Car" or Truck. New Car New Car Used Truck Used Car New Truck Used Truck Used Car How can I make Excel Count the number of "Car" that are ALSO "New" I've tried some COUNTIF commands with an AND command in there. I may be way off, but I also could just have a ) in the wrong place. I need it to tell me that {New Cars=2}{New Trucks=1}..etc... I hope I explained this ? alright. Thanks for all your help. -- lherndo ------------------------------------------------------------------------ lherndo's Profile: http://www.excelforum.com/member.php...o&userid=15569 View this thread: http://www.excelforum.com/showthread...hreadid=530538 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNTIF help please
I had never heard of the SUMPRODUCT function. That did the trick. Thanks! -- lherndo ------------------------------------------------------------------------ lherndo's Profile: http://www.excelforum.com/member.php...o&userid=15569 View this thread: http://www.excelforum.com/showthread...hreadid=530538 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Countif Formula /Sort Bug??? | Excel Discussion (Misc queries) | |||
COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
COUNTIF COMBINATION?? | Excel Worksheet Functions | |||
Combining IF and COUNTIF based on two columns | Excel Discussion (Misc queries) | |||
Countif - Countif | Excel Worksheet Functions |