Excel SumIf or SumProduct Help

I have a column off to the right of a long spread sheet that totals up the amount we spend at particular companies.

=SUMIF(C:C, "TigerDirect",L:L)

What I would like to do is instead of having to Type Each company in the Formula I would like it to pull the company name from the column to the right.

Something like

 =SUMIF(C:C, "=O15",L:L)

However that does not work.
Jeremy PierceAGMAsked:
Who is Participating?
 
Naresh PatelTraderCommented:
=SUMIF(C:C,O15,L:L)
0
 
Naresh PatelTraderCommented:
Just change to this
=SUM(C:C,O15,L:L)

thanks
0
 
Jeremy PierceAGMAuthor Commented:
I feel stupid now...that was easy.

Thanks! Many more to come. Cause they want to change all the workbooks for next year.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.