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

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

=SUMIF should be sufficient.

For Service code 3 for instance

=SUMIF(B:B,3,C:C)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=561658

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

This is great. How do I indicate the last used cell in the coloumn?
Thanks
John

daddylonglegs wrote:

=SUMIF should be sufficient.

For Service code 3 for instance

=SUMIF(B:B,3,C:C)


This worked for me. Thanks
John