Excel 'IF' function

baby-mechanic

Hi guys

I'd like to have Excel add three bits of data, 'S', 'I' and 'H', from columns, so I can see how many of each were used for each month.

Have thought of using the 'IF' function, but can't see how to get it to work on this.

Many thanks

lazer

Hi,

If you're just adding 3 colums of Data, all you need is a simple addition formula

eg: = S1+I1+H1

Can you clairfy what you need the formula to do?

googler

or SUM(Cell1,Cell2,Cell3) to give you a total of three cells.

Again, what are you trying to do?

baby-mechanic

Thought I'd explained it better than i had !

In a column that is representing a month, I will have several cells containg the letter 'S', several with 'I', and several with 'H'.

I'd like to be able to set up a function that will total the number of each of these letters in the column.

I realise that i will probably need three separate functions

sprouter

Do the cells you are analysing only contain either S, I or H? If so, the COUNTIF function sounds like the one you want. SUMIF might also be appropriate if you're looking to add the amounts according to the criteria selected. If the cells contain more than S, I, H, then you'll probably also want to combine the above function with the LEFT() function (assuming the S, I , H always appear as the first character).
Jeez - I see what you mean about trying to explain it!

rmg1

In three separate cells, you can use the Countif function.
The syntax would be :-
=COUNTIF(H:H,"S")
=COUNTIF(H:H,"I")
=COUNTIF(H:H,"H")

This will simply count the number of times each letter appears in the column (always assuming it's the only letter in the cell).

baby-mechanic

yes, the is only one letter in each cell, either 'S', 'I' or 'H', and I'm grateful for the ability too count them.

rmg1 - what does the 'H:H,' part represent ?
especially if I'm assessing a column of up to 31 cells ?

baby-mechanic

Hi rmg1

have worked out the answer to my question to you

many thanks folks