Ignoring #VALUE in formula calculations

		Microsoft Office Forums > Microsoft Excel > Excel
Ignoring #VALUE in formula calculations

11-09-2018, 01:29 AM

NickFazer

Windows 7 64bit Ignoring #VALUE in formula calculations

Office 2003

Novice

Join Date: Sep 2018

Posts: 8

Ignoring #VALUE in formula calculations

Hi

Is there a Function or can a macro be used that will ignore #VALUE in a sum formula?

Thanks

Nick

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Orphan/widow control ignoring single line	seanspotatobusiness	Word	8	07-17-2018 03:46 PM
Any way to ignore neighboring cell while ignoring blank cells in SUMPRODUCT?	dominicrudin	Excel	1	01-08-2017 10:38 AM
Calculations	etobias	Word	2	11-09-2016 10:14 AM
View by date ignoring folders?	adamgram	Outlook	0	09-12-2013 07:22 AM
Merge Field Ignoring Zeros	Welshie82	Mail Merge	2	05-04-2012 01:56 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:01 AM.