Posted to microsoft.public.excel.misc

jlclyde

external usenet poster

Posts: 410

Sumproduct to divide

I am trying to write a formula using Sumproduct to dived data. I
understand that the reciprocal of a number multiplied is the same as
dividing so Sumproduct shoudl work. the problem is that there are
blanks in the data and then it is diving by one.
=Sumproduct(A1:A5,1/B1:B5) This works fine if there are no 0 or
blanks.

Thanks,
Jay

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
Divide By help?	kirstie adam	Excel Worksheet Functions	2	December 5th 06 04:23 PM
divide	Marc	Excel Discussion (Misc queries)	2	September 22nd 06 02:34 AM
divide by zero	belliotb	Excel Worksheet Functions	3	May 18th 06 05:01 PM
divide by 0	sony654	Excel Worksheet Functions	4	April 24th 05 08:10 AM
Divide one row over other row I dont wont to divide one number	Rick	Excel Discussion (Misc queries)	0	March 4th 05 07:13 PM

All times are GMT +1. The time now is 07:13 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us