Formula to add numbers and exclude text values

[jpruffle]

Hi,

Hope someone can help. I need a formula that calculates the values of 5 seperate cells located in different places throughout my sheet. The value will either be numerical or display a text value (normally "RD"). If it displays text I do not want that value counted. So it literally just totals the number values.

Thanks

[zbor]

=SUM(cell1;cell2;...) will sum numbered cells only, text won't effect it.

Edit: also =COUNT(cell1;cell2;cell3...) IF you want all to be counted you can use =COUNTA(cell1;cell2;cell3...)

[mubashir aziz]

Simply Use

=Count(A5,C6,D8,F7) it will count only numeric values

= Counta(A5,C6,D8,F7) will count all value

[jpruffle]

Thank you for the quick reply. Neither seem to work.

Effectively I want to add:

=SUM(C42+C34+C26+C18+C10)

Any of those value could contain text. When they do this formula and count return #VALUE!. I need the calculation to exclude text and just add numbers.

Any ideas?

[zbor]

not +... put ; (or ,)

=SUM(C10;C18;C26...)

[arthurbr]

As zbor indicates, when you use C4+C34, etc.. you will get an error if cell(s) contain something else than numbers

[DonkeyOte]

So either

=SUM(C10,C18 etc...)

or if you have a large dataset, say you want to sum 50 values and don't want to type them / reference them individually then given they are seemingly equal spaced you could also use a Sumproduct approach, eg:

=SUMPRODUCT(--(MOD(ROW(C10:C402)-10,8)=0),C10:C402)

[jpruffle]

Thank you all for your help.