|
|
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
 |
|
|
Thread Tools | Display Modes |
Apr 3rd, 2002, 08:46 AM
|
#1 |
|
Board Regular
Join Date: Apr 2002
Posts: 76
|
Here goes
I have three columns of data I want to have the computer to tell me how many fans I have from a certain location. example: B 1 Fan B 1 Boot c 1 Fan B 1 Car B 1 Fan I can use a countif statement to tell that I have three fans but, I want something that will tell me how many fans do I have that are from the B location in column a. and then how many boot from the b location etc... Thanks |
|
|
|
Apr 3rd, 2002, 08:50 AM
|
#2 |
|
MrExcel MVP
Join Date: Feb 2002
Location: Austin, Texas USA
Posts: 11,654
|
Have you considered using a PivotTable?
|
|
|
|
|
Apr 3rd, 2002, 08:50 AM
|
#3 |
|
MrExcel MVP
Join Date: Feb 2002
Location: Allentown, PA
Posts: 2,510
|
__________________
~Anne Troy |
|
|
|
|
Apr 3rd, 2002, 08:51 AM
|
#4 |
|
Board Regular
Join Date: Feb 2002
Location: Where the wild roses grow
Posts: 285
|
Best thing to use is the sumproduct formula, works like this:
=SUMPRODUCT((A:A="B")*(B:B="1")*(C:C="Fan")) This will look down the 3 columns. If there's a 'B' in column A with a '1' next to it in column B and a 'Fan' next to that in column C it'll return a 1 and do the same all the way down the page. Obviously you can tinker with this to make it count what you want Audiojoe I give love a bad name |
|
|
|
|
Apr 3rd, 2002, 08:57 AM
|
#5 | |
|
MrExcel MVP
Join Date: Feb 2002
Location: The Hague
Posts: 50,317
|
Quote:
will for example give you the desired count. Try also using PivotTables. |
|
|
|
|
|
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
