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