Posted to microsoft.public.excel.misc

Mike H[_4_] Mike H[_4_] is offline

external usenet poster

Posts: 19

running sum needed with #N/A in array

hi

=SUMIF(B2:B15,"<#N/A")

Mike

On Thu, 22 Jan 2009 13:01:01 -0800, Lois
wrote:

I am trying to get a running sum from a list of VLookups where some of the
values have yet to be entered. Therefor some of the cells show as #N/A and
the sum formula SUM(B2:B15) is not working. How can I fix this. (just in case
not clear b2 is 5:47, B3 is 5:52 B4:b15 are currently #N/A but will change on
later dates)

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
RUNNING TOTALS...FORMULA NEEDED	Liz	Excel Worksheet Functions	2	July 31st 07 07:43 PM
Maybe an array is needed?	Arturo	Excel Worksheet Functions	1	September 6th 06 01:26 PM
Running total array?	uw805	Excel Worksheet Functions	1	June 9th 06 04:18 AM
Formula Needed to Compare Dates and return a running total	Cmonroe	Excel Worksheet Functions	3	June 8th 06 08:54 PM
Urgent Help needed - I need to stop a process that is running forever in Excel	shadestreet	Excel Discussion (Misc queries)	2	October 6th 05 09:59 PM

All times are GMT +1. The time now is 04:57 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us