|
|
#4
05-22-2011, 02:52 AM
|
|||
|
|||
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 |
Windows 7 32bit 
Office 2007
Threaded Mode