Making a certain formula

At my work I use exel to separate rooms by who made them, and then have to add the room rates separated by who made them. So in one colum of the sheet are who made them (either marked by F, S, or C) and another colum for rate. So what I was looking for was a formula that would add up the room rates based opon if there was a F, S, or C in another colum. Is this possible? Thanks everyone, I know my discription is a little rough.

---Kenny

Hi Kenny,

The SUMPRODUCT function is the best solution. Here's an example of how it would sum the C entries if the F, S or C markers are in A1:A5 and the amounts to be summed are in the adjacent range (simply tweak as necessary):

=SUMPRODUCT(--(A1:A5="C"),(B1:B5))

HTH

Robert

Thanks that helped a lot, now how about if I need to include mulitiple colums? What I have is =SUMPRODUCT(--(B5:B26,H5:H26,N5,N26="F"),(D5:D26,J5:J26,P5:P26))
and its saying #VALUE! Is there something wrong with the formula that you can see? Thanks again

---Kenny

Thanks a ton, that worked great! However now when I try to make the same formula in a different cell using another simbol (S or C) it doesn't work. Will it not work if you are referring to the same cells as the other formula? Is there a way to get around that? Thanks

---Kenny

Originally Posted by DogStar5988

Thanks a ton, that worked great! However now when I try to make the same formula in a different cell using another simbol (S or C) it doesn't work. Will it not work if you are referring to the same cells as the other formula? Is there a way to get around that? Thanks

---Kenny

Oops nevermind I figured it out. Thanks a lot everyone, you just made me a hero at work :P.

---Kenny