Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 11-14-2017, 06:14 AM
NBVC's Avatar
NBVC NBVC is offline Formula to make sum based on multiple conditions, HELP! Windows 10 Formula to make sum based on multiple conditions, HELP! Office 2013
The Formula Guy
 
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default

Try:

Code:
=SUMIFS(CODES!D$2:D$34,CODES!$C$2:$C$34,$B3)


copied down and across.

or if you need to also match the column headers because they may not be in consistent order, then

Code:
=SUMIFS(INDEX(CODES!$D$2:$F$34,,MATCH(C$2,CODES!$D$1:$F$1,0)),CODES!$C$2:$C$34,$B3)
Reply With Quote
 

Tags
sum vlookup formula



Similar Threads
Thread Thread Starter Forum Replies Last Post
Merging 2 different cells containing IF formula & change in cell values based on multiple time frame jay_excel Excel 0 07-29-2017 11:04 PM
Index to return value based on 2 conditions george batshon Excel 2 01-28-2017 05:11 AM
Formula to make sum based on multiple conditions, HELP! How to make MATCH/INDEX formula return multiple successive responses. danigirl121 Excel 7 06-08-2016 01:57 PM
Excel Formula for Multiple Conditions & Results nowco Excel 4 03-16-2016 11:24 AM
Formula to make sum based on multiple conditions, HELP! How to Subtract value in table, based on two different conditions nitemath2 Excel 1 06-19-2015 01:28 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:06 PM.


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