values in several columns, how to make sum of them?
Posted by schuurke28 on September 04, 2001 9:33 AM
i have 5 columns.
in all columns there could be several names like john, els, ...
I want to make the sum or the count of each identical name. i can't do it with a pivot table because this will give me the total/name/column
i.e.:
i want to know how many times the name els is in the 5 columns, just the count of the name els
Posted by Sean Tobin on September 04, 2001 9:52 AM
In a blank cell type" =countif(A1:F10,B1) "
The first part, A1:F10, is the area that you want to search. The second part, A2, is the cell that contains the name you want counted.
Posted by Aladin Akyurek on September 04, 2001 9:53 AM
If each cell contains a single name,
=COUNTIF(A1:E100,"els")
will do what you want.
Aladin
