Totaling up a column

  • Thread starter Thread starter jliz2803
  • Start date Start date
J

jliz2803

I have a column that has either the text value of DSM or eBiz I want to
be able to, in two other cells add up the number of times DSM appears
in one cell and the number of times eBiz appears in another cell. Is
there a way to say go through this column and if it equals DSM
increment one variable and if it is eBiz increment another variable,
and display the totals for each?
 
To do this, you need to use a matrix type formula.
Suppose your data is in cells A1:A10

In the cell you want the total number of "DSM" values, type the following
formula:

=SUM(IF(A1:A10="DSM",1,0))

IMPORTANT: Press and hold Ctrl-Shift and press Enter once you have typed in
the formula.
The formula will now appear as {=SUM(IF(A1:A10="DSM",1,0))}
The braces indictae this is a matrix type formula.

Proceed in the same way for the other cell:

=SUM(IF(A1:A10="eBiz",1,0))
 
Back
Top