|
|
#5
10-17-2019, 09:00 PM
|
|||
|
|||
Try this. In P17 then copy to other cells.
=SUMIF($Y17:$AG17,Q17,$X17:$AF17) 
|
| Tags |
| sumif |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Borders on merged cells also appearing on unwanted adjacent cells | MrsC | Word Tables | 2 | 08-19-2019 09:14 AM |
 Need help with an IF formula, which is based on adjacent cells being in the Top 30% of a range
|
FarStar | Excel | 17 | 07-26-2017 07:55 AM |
| Conditional formating all cells in an array based on adjacent cells | deejay | Excel | 6 | 12-20-2016 12:00 PM |
|
Adding adjacent cells and having the sum appear in two separate places
|
Seamus Sean | Excel | 4 | 12-11-2016 10:34 PM |
| Using alternating borders in adjacent cells | jrevard | Word | 0 | 10-15-2015 09:07 AM |
Windows XP 
Office 2007
Threaded Mode