J
John
I already do this using a macro but thought it might be possible with
just a cell function.
Column B has either 1,2,3, or 4 in it. These are service codes. Column C
has hours in it. I want total hours per service in another place on the
sheet. So... it's find a all the 1's say, multiply each by the hours in
the same row in C and add that prduct to another cell. Do that until
there is a blank in coloumn B. Do it, also, for 2,3, and 4.
The macro is a simple while/wend.
thanks
John
just a cell function.
Column B has either 1,2,3, or 4 in it. These are service codes. Column C
has hours in it. I want total hours per service in another place on the
sheet. So... it's find a all the 1's say, multiply each by the hours in
the same row in C and add that prduct to another cell. Do that until
there is a blank in coloumn B. Do it, also, for 2,3, and 4.
The macro is a simple while/wend.
thanks
John