software

I have review a proceedure written by Ashish Mathur but I can not get it to
work. It continues to return a blank cell. Even when I copy the exact
information the the example he gives
--
JW

Hi Jerry,

Post the procedure and what you are trying to do.

Regards,
Howard

quot;Jerryquot; gt; wrote in message
...
gt;I have review a proceedure written by Ashish Mathur but I can not get it to
gt; work. It continues to return a blank cell. Even when I copy the exact
gt; information the the example he gives
gt; --
gt; JW
I have a data list which changes constantly depending on the work being
performed. I want to get a total for the individual and the job which is
being performed. Data looks similar to this:

Employee Job Job 2 Job3
John 5 4 250
chris 2
dave 1

John 3

This continues for 500 rows. I am looking to be able to sum the jobs for
each employee. Sub Totals and Filters will not work because this sheet is
linked to many other tabs with calculations and vlookups.

The proceedure written by Ashish Mathur which is linked in microsoft help
under vlookup does not seem to work when I try the exact example. It is
however exactly that I need
--
JWquot;L. Howard Kittlequot; wrote:

gt; Hi Jerry,
gt;
gt; Post the procedure and what you are trying to do.
gt;
gt; Regards,
gt; Howard
gt;
gt; quot;Jerryquot; gt; wrote in message
gt; ...
gt; gt;I have review a proceedure written by Ashish Mathur but I can not get it to
gt; gt; work. It continues to return a blank cell. Even when I copy the exact
gt; gt; information the the example he gives
gt; gt; --
gt; gt; JW
gt;
gt;
gt;

The equation looks like this
=IF(ISERROR(INDEX(N8:O411,SMALL(IF(N8:N411=N415,RO W(N8:N411)),ROW(1:1)),2)),quot;quot;,INDEX(N8:O411,SMALL(I F(N8:N411=N415,ROW(N8:N411)),ROW(1:1)),2))
--
JWquot;L. Howard Kittlequot; wrote:

gt; Hi Jerry,
gt;
gt; Post the procedure and what you are trying to do.
gt;
gt; Regards,
gt; Howard
gt;
gt; quot;Jerryquot; gt; wrote in message
gt; ...
gt; gt;I have review a proceedure written by Ashish Mathur but I can not get it to
gt; gt; work. It continues to return a blank cell. Even when I copy the exact
gt; gt; information the the example he gives
gt; gt; --
gt; gt; JW
gt;
gt;
gt;