Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-01-2015, 05:22 AM
Haha88 Haha88 is offline Better formula please Windows 8 Better formula please Office 2010 32bit
Advanced Beginner
Better formula please
 
Join Date: Mar 2015
Posts: 75
Haha88 is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 03-01-2015, 08:49 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Better formula please Windows 7 64bit Better formula please Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
  #3  
Old 03-01-2015, 03:36 PM
Haha88 Haha88 is offline Better formula please Windows 8 Better formula please Office 2010 32bit
Advanced Beginner
Better formula please
 
Join Date: Mar 2015
Posts: 75
Haha88 is on a distinguished road
Default

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,
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Better formula please formula help rich_cirillo Excel 3 09-26-2012 11:41 PM
Better formula please formula help excelledsoftware Excel 8 03-25-2012 08:49 AM
Better formula please Help with formula please. AndrewSE Excel 3 04-05-2011 08:50 PM
Better formula please Help with Formula Corca Excel 6 02-22-2010 09:40 PM
Better formula please If formula sixhobbits Excel 1 10-02-2009 08:02 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:46 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft