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

if function within excel

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

If function within Excel

ResolvedVersion 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:

Finding your worksheets quickly

The arrows to the left of the worksheets are used to move between one sheet at a time or first / last worksheet, but if you right click on the arrow buttons it gives you all worksheets in your workbook.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.