Sumproduct help

  • Thread starter Thread starter Kirstie Adam
  • Start date Start date
K

Kirstie Adam

Hi All,

I think sumproduct is the right thing to use - but i need help!

I have a row of columns in which "TOTAL TO FEE" appears a number of times.
What i want to do is sum the value of each cell in a row which has the
column heading "TOTAL TO FEE".

I tried this:


=SUMPRODUCT(($C$6:$IV$6 = "TOTAL TO FEE")*(C7:IV7))

But just get #REF!

Can anyone offer any suggestions please?

Kirstie
 
Try this:

=SUMIF($C$6:$IV$6,"TOTAL TO FEE",C7:IV7)

Does that help?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
 
Hi Ron,

Thanks for quick response.

But no, still getting the REF! error sign.

Am stumped!

Kirstie
 
Ron,

I searched through my sheet and found a rogue expression which had an
error - deleted that and it now works.

Thanks very much for your help

Kirstie
 
Back
Top