Thread: [Solved] SUMIF Formula question
View Single Post
 
Old 05-21-2011, 11:34 PM
jcaswell jcaswell is offline Windows 7 32bit Office 2007
Novice
  
Join Date: May 2011
Posts: 13
jcaswell is on a distinguished road
Default SUMIF Formula question
I want to use the second variable in the SUMIF formula to refer to the contents of a cell rather than a string. So, something like this:

SUMIF(C15:C45,T10,F15:F45)

Where the T10 in the formula refers to the contents of a cell that contains a text string that I want to use as the comparison. I feel that I ought to be able to do this, but cannot find the right syntax.

Can anyone help?
Reply With Quote