if function within excel

Public Schedule Face-to-Face & Virtual Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » If function within Excel

If function within Excel

resolvedResolved · High Priority · Version 2003

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

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.


 

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


Server loaded in 0.07 secs.