ExcelBanter - View Single Post

paul

sumproduct
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

--
paul

remove nospam for email addy!

"John" wrote:

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