|
|
#3
03-05-2018, 05:22 AM
|
|||
|
|||
Quote:
Can we have it so that instead of looking for a specific value, in this case G7, it looks within a range of values? I have 36 colours from which to look for, and if I use the formula as you specified it, I would need 36 rows, one for each colour, which would be messy. I would need the formula to first group all the colours that appear above (as in column G), and then do the sum. Can you give me a hand with that? Thanks a lot!!! 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 How to import list from Excel into drop-down list into word
|
ahw | Word VBA | 43 | 02-28-2020 08:11 PM |
| Drop down list | emukiss10 | Word VBA | 0 | 11-20-2017 02:18 AM |
|
Having a Drop-down list in Word referring to an Excel list
|
celias | Word VBA | 3 | 07-11-2016 11:40 PM |
|
Drop Down List Help
|
ksigcajun | Word | 3 | 05-09-2014 05:35 AM |
| Drop down list, Can it be done??? | garethreid | Outlook | 0 | 08-09-2012 06:08 AM |
Mac OS X 
Office 2016 for Mac
Threaded Mode