|
|
#1
05-21-2011, 11:34 PM
|
|||
|
|||
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? 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Need Help With SUMIF Formula In R1C1 Style
|
Todd | Excel | 9 | 02-27-2010 08:30 PM |
|
If formula
|
sixhobbits | Excel | 1 | 10-02-2009 08:02 AM |
|
Need help with a formula
|
tinkertron | Excel | 11 | 04-16-2009 11:43 PM |
| Categories question & replying with attachment question | glitzymama | Outlook | 0 | 03-15-2006 09:32 AM |
|
Multiple criteria in SUMIF?
|
pumpkin head | Excel | 1 | 02-17-2006 09:06 AM |
Windows 7 32bit 
Office 2007
Threaded Mode