If function within Excel

Resolved · High Priority · Version 2003

Tue 3 Nov 2009, 10:10 Delegate Michelle said...

Michelle has attended:
Excel Advanced course

If function within Excel

I have a spreadsheet that has alpha in each cell. I am trying to calculate the total of 'H' & the total of 'S' on each of 10 lines on the spreadsheet. Please can you tell me how I can do this so that I can get the total of 'H' seperate to the total of 'S'?
Thank you

Tue 3 Nov 2009, 15:04 Trainer Amanda said...

RE: If function within Excel

Hello Michelle

Thank you for your question.

I think that COUNTIF would work for this.

To count the number of times H appears:
=COUNTIF("H",range) where range refers to the cell range within which you would like Excel to count the number of times H occurs.

The same should work for counting the number of times S appears, if you replace "H" with "S" in the above formula.

Kind regards
Amanda

Tue 10 Nov 2009: Automatically marked as resolved.

Training courses

	98.8 % recommend us
	More live stats...

Training information:

Excel tip:

Create Equations in Excel 2010

Here's how to create basic mathematical
equations in your Excel 2010 worksheet.

1) On the Ribbon, click the Insert tab
2) In the Symbols group, click the arrow next to Equation
3) Select from the equations and the equation will be inserted in a text box

Or you can create your own equation:

1) Insert and select the text box
2) On the Ribbon, click the Insert tab
3) In the Symbols group, click Equation
4) The Equation Tools Design Ribbon will now be displayed

View all Excel hints and tips