#1
|
|||
|
|||
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? |
#2
|
||||
|
||||
Try:
=SUMPRODUCT((C15:C45=T10)*(F15:F45))
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
||||
|
||||
Hi,
Quote:
Code:
=SUMIF(C15:C45,">100",F15:F45) Code:
=SUMIF(C15:C45,">"&T10,F15:F45) If you want the > operator in cell T10 too, then you would put this in T10: Code:
=">100" Code:
=SUMIF(C15:C45,T10,F15:F45) |
#4
|
|||
|
|||
Colin
Thank you - the comparison I was trying to do was not mathmatical but textual (i.e. sum if the comparison cell was 'Microsoft'). Thus the ">" (or rather I tried "=" didn't work. However, the article you supplied did help, and what finally worked was SUMIF(G15:G50,""&T15,H15:H50). T15 contained the text I wanted to compare with the array. Thank you |
|
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 |