| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing where values
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 -- AmyTaylor ------------------------------------------------------------------------ AmyTaylor's Profile: http://www.excelforum.com/member.php...o&userid=20970 View this thread: http://www.excelforum.com/showthread...hreadid=544345 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Summing where values
Hi everyone, I have worked it out, used sum !! Thanks Amy xx -- AmyTaylor ------------------------------------------------------------------------ AmyTaylor's Profile: http://www.excelforum.com/member.php...o&userid=20970 View this thread: http://www.excelforum.com/showthread...hreadid=544345 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to lookup multiple values and summing them up in one cell | Excel Worksheet Functions | |||
| Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
| Sumproduct not working when summing values between two numbers | Excel Worksheet Functions | |||
| Summing values within a range | Excel Discussion (Misc queries) | |||
| What is the best method for summing values where you want 2 value. | Excel Discussion (Misc queries) | |||
Linear Mode
