| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUM of #N/A cells (#N/D in italian EXCEL)
Hi, I'd like to know how I can sum, say 100 cells among which there is one cell with #N/A, without getting #N/A as a result. Thamks in advance for your support Paolo Italy -- kayard ------------------------------------------------------------------------ kayard's Profile: http://www.excelforum.com/member.php...o&userid=24716 View this thread: http://www.excelforum.com/showthread...hreadid=565187 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUM of #N/A cells (#N/D in italian EXCEL)
In English, I'd use:
=sum(if(isnumber(a1:a100),a1:a100)) This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it correctly, excel will wrap curly brackets {} around your formula. (don't type them yourself.) Adjust the range to match--but you can't use the whole column. kayard wrote: Hi, I'd like to know how I can sum, say 100 cells among which there is one cell with #N/A, without getting #N/A as a result. Thamks in advance for your support Paolo Italy -- kayard ------------------------------------------------------------------------ kayard's Profile: http://www.excelforum.com/member.php...o&userid=24716 View this thread: http://www.excelforum.com/showthread...hreadid=565187 -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUM of #N/A cells (#N/D in italian EXCEL)
Try something like this: English version: =SUMIF(A1:A100,"<#N/A",A1:A100) Italian version? =SUMIF(A1:A100,"<#N/D",A1:A100) Does that help? Regards, Ron -- Ron Coderre ------------------------------------------------------------------------ Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419 View this thread: http://www.excelforum.com/showthread...hreadid=565187 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUM of #N/A cells (#N/D in italian EXCEL)
And the *short* Italian version:<bg
=SUMIF(A1:A100,"<#N/D") -- Regards, RD ---------------------------------------------------------------------------- ------------------- Please keep all correspondence within the Group, so all may benefit ! ---------------------------------------------------------------------------- ------------------- "Ron Coderre" wrote in message ... Try something like this: English version: =SUMIF(A1:A100,"<#N/A",A1:A100) Italian version? =SUMIF(A1:A100,"<#N/D",A1:A100) Does that help? Regards, Ron -- Ron Coderre ------------------------------------------------------------------------ Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419 View this thread: http://www.excelforum.com/showthread...hreadid=565187 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel auto formats cells with numbers - Can it be disabled? | Setting up and Configuration of Excel | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| EXCEL, VSTO: Fastest way to access multiple cells | Excel Discussion (Misc queries) | |||
| How can I have excel search and add multiple cells to find a targe | Excel Discussion (Misc queries) | |||
| How do I merge cells in Excel, like just 2 cells to make one big . | Excel Discussion (Misc queries) | |||
Hybrid Mode
