Sumproduct help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kirstie Adam - 26 Mar 2008 11:48 GMT

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

Reply to this Message

Ron Coderre - 26 Mar 2008 11:58 GMT

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 All,
>
[quoted text clipped - 13 lines]
>
> Kirstie

Reply to this Message

Kirstie Adam - 26 Mar 2008 12:04 GMT

Hi Ron,

Thanks for quick response.

But no, still getting the REF! error sign.

Am stumped!

Kirstie

> Try this:
>
[quoted text clipped - 27 lines]
>>
>> Kirstie

Reply to this Message

Kirstie Adam - 26 Mar 2008 12:08 GMT

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

> Hi Ron,
>
[quoted text clipped - 37 lines]
>>>
>>> Kirstie

Reply to this Message

Rate this thread: