|
|
#1
03-01-2015, 05:22 AM
|
|||
|
|||
Better formula please
Hi
Is there better formula to trim down the below sumif function? =SUMIF('Group Consolidated'!$C$2:$AL$2,CONCATENATE(B$8,".",B$9), 'Group Consolidated'!$C$49:$AL$49)+SUMIF('Group Consolidated'!$C$2:$AL$2,CONCATENATE(B$8,".",B$9), 'Group Consolidated'!$C$74:$AL$74) Many thanks. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 formula help
|
rich_cirillo | Excel | 3 | 09-26-2012 11:41 PM |
|
formula help
|
excelledsoftware | Excel | 8 | 03-25-2012 08:49 AM |
|
Help with formula please.
|
AndrewSE | Excel | 3 | 04-05-2011 08:50 PM |
|
Help with Formula
|
Corca | Excel | 6 | 02-22-2010 09:40 PM |
|
If formula
|
sixhobbits | Excel | 1 | 10-02-2009 08:02 AM |
Windows 8 
Office 2010 32bit
Threaded Mode