Styjun

Choose columnsep depending on page

What is the fundamental difference between catching whales and hunting other animals?

Initializing variables in an "if" statement

soda water first stored in refrigerator and then outside

Will Jimmy fall off his platform?

What can a novel do that film and TV cannot?

How to say "just a precision" properly in English?

SOQL Query (or other means) to get the icon assigned to an object

What is the meaning of "prairie-dog" in this sentence?

Wouldn't putting an electronic key inside a small Faraday cage render it completely useless?

Changing text size or line height of QGIS attribute table?

Why do Klingons use cloaking devices?

When is one 'Ready' to make Original Contributions to Mathematics?

How to get the speed of my spaceship?

Is this standard Japanese employment negotiations, or am I missing something?

What happens if the limit of 4 billion files was exceeded in an ext4 partition?

How do I talk to my wife about unrealistic expectations?

Examples of fluid (including air) being used to transmit digital data?

Machine Learning Golf: Multiplication

Why does mean tend be more stable in different samples than median?

Taking my Ph.D. advisor out for dinner after graduation

My professor has told me he will be the corresponding author. Will it hurt my future career?

Why does this function pointer assignment work when assigned directly but not with the conditional operator?

Tiny URL creator

How to add (sum) items in two columns

How do I create an Excel (.XLS and .XLSX) file in C# without installing Microsoft Office?Simple Pivot Table to Count Unique ValuesHow can I Use autofilter in Excel if the person is occurring in two columns?Compare Two Pivot TablesDisplay sum in text and numeric value excel sheetCalculate sum of columns data in Excel Pivot table base on columns nameExcel - Return Count of Unique Values Based on Two ColumnsAdd column in power pivot from other tableCompare two Excel columns A&B and add in one cell the data of a third column C of the entries not present in APivot Table won't sum

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

I have two columns with a list of Vehicle Types, I want to be add each type of vehicle in both column and display the total number of each vehicle type. I have tried a pivot table but not sure how to get it to add the second column. Thank you in advance for your help.

excel excel-formula

share|improve this question

edited Mar 25 at 20:30

PeterT

4,93311 gold badge1010 silver badges3232 bronze badges

asked Mar 25 at 20:20

NARIHNARIH

1

• 
  
  
  

  
  4
  

  
  
  
  
  
  

  
  
  All you need is to use the COUNTIF formula in column D. So your formula for cell D1 would be =COUNTIF($A$1:$B$9,C1)
  
  – PeterT
  Mar 25 at 20:34
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  PeterT Thank you for the reply, I should been more clear with my question and my example, basically I have two columns with names, I want to be able to count in each column how many times a name appears and output a list with the names and the count. I can accomplish this with a pivot table when its only one column but unable with two. Is it possible to create two pivot table for each column and add them together? or another way.
  
  – NARIH
  Mar 26 at 0:34
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  You can do this Power Query (aka Get&Transform). One way is to make each column a separate Query. Then create a new Query using the Append operation. Finally, group by the resultant column, and use the Count Rows function. All this can be done within the User Interface.
  
  – Ron Rosenfeld
  Mar 26 at 1:02
  

  
  
  
  

add a comment | 

0

I have two columns with a list of Vehicle Types, I want to be add each type of vehicle in both column and display the total number of each vehicle type. I have tried a pivot table but not sure how to get it to add the second column. Thank you in advance for your help.

excel excel-formula

share|improve this question

edited Mar 25 at 20:30

PeterT

4,93311 gold badge1010 silver badges3232 bronze badges

asked Mar 25 at 20:20

NARIHNARIH

1

• 
  
  
  

  
  4
  

  
  
  
  
  
  

  
  
  All you need is to use the COUNTIF formula in column D. So your formula for cell D1 would be =COUNTIF($A$1:$B$9,C1)
  
  – PeterT
  Mar 25 at 20:34
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  PeterT Thank you for the reply, I should been more clear with my question and my example, basically I have two columns with names, I want to be able to count in each column how many times a name appears and output a list with the names and the count. I can accomplish this with a pivot table when its only one column but unable with two. Is it possible to create two pivot table for each column and add them together? or another way.
  
  – NARIH
  Mar 26 at 0:34
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  You can do this Power Query (aka Get&Transform). One way is to make each column a separate Query. Then create a new Query using the Append operation. Finally, group by the resultant column, and use the Count Rows function. All this can be done within the User Interface.
  
  – Ron Rosenfeld
  Mar 26 at 1:02
  

  
  
  
  

add a comment | 

I have two columns with a list of Vehicle Types, I want to be add each type of vehicle in both column and display the total number of each vehicle type. I have tried a pivot table but not sure how to get it to add the second column. Thank you in advance for your help.

excel excel-formula

share|improve this question

edited Mar 25 at 20:30

PeterT

4,93311 gold badge1010 silver badges3232 bronze badges

asked Mar 25 at 20:20

NARIHNARIH

1

share|improve this question

edited Mar 25 at 20:30

PeterT

4,93311 gold badge1010 silver badges3232 bronze badges

asked Mar 25 at 20:20

NARIHNARIH

1

share|improve this question

edited Mar 25 at 20:30

PeterT

4,93311 gold badge1010 silver badges3232 bronze badges

asked Mar 25 at 20:20

NARIHNARIH

1

edited Mar 25 at 20:30

PeterT

4,93311 gold badge1010 silver badges3232 bronze badges

edited Mar 25 at 20:30

PeterT

4,93311 gold badge1010 silver badges3232 bronze badges

asked Mar 25 at 20:20

NARIHNARIH

1

asked Mar 25 at 20:20

NARIHNARIH

1