#1
|
|||
|
|||
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. |
#2
|
||||
|
||||
A better formula? What's wrong with this one?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
Nothing wrong with the formula but I thought there's may be a better/shorter formula than above.
I'm looking for =SUMIF('Group Consolidated'!$C$2:$AL$2,CONCATENATE(B$8,".",B$9), return of =sum('Group Consolidated'!$C$49:$AL$49,'Group Consolidated'!$C$74:$AL$74) rather than have to form 2 x sumif. Is it possible? Thanks, |
Thread Tools | |
Display Modes | |
|
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 |