Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 11-15-2017, 02:03 AM
ilsel ilsel is offline Formula to make sum based on multiple conditions, HELP! Windows 10 Formula to make sum based on multiple conditions, HELP! Office 2010 64bit
Novice
Formula to make sum based on multiple conditions, HELP!
 
Join Date: Nov 2017
Posts: 3
ilsel is on a distinguished road
Talking

Quote:
Originally Posted by NBVC View Post
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)
I found what I did wrong!
Thank you so much, lifesaver.
Greets Ilse.
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 01:07 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