Summing where values

  • Thread starter Thread starter AmyTaylor
  • Start date Start date
A

AmyTaylor

HI everyone, I have a range of cells in rows and columns.
I want to be able to sum each row between A and E.

The thing is that sometimes A,B,C,D or E contains a letter, and this
results in #VALUE! result.

Is it possible to change the formulae from a simple sum(A1:E2) etc to
something which will exclude those cells where the character is a
letter and only sum where the character is a number.

Thanks for your help

Love Amy xx
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMIF "value if false" not working 2
Excel Sum numbers in cells that also contain text 34
Scrabble Value calculation for Welsh words 0
Excel formula, sum the value cell and if empty cell left blank 0
Offset, sum down to the first blank row 6
Sum Values from different column 1
XL2002 SUM with a twist... 4
Need sum of top values in a range based on criteria 5

Back
Top