Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 11-05-2019, 07:57 PM
Karen615 Karen615 is offline Sumif Windows 7 64bit Sumif Office 2010 64bit
Competent Performer
Sumif
 
Join Date: Jun 2011
Location: Chicago
Posts: 145
Karen615 is on a distinguished road
Default Sumif

In cell range A3:A100, the user can choose from a drop-down that contains either A, B, C or D.

I want to sum the range using the below values.
A=100
B=75
C=50


D=25

Can someone help me with this?
Your help is greatly appreciated.
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sumif within VBA Lee-Ann Excel Programming 6 09-28-2017 07:38 AM
Sumif SUMIF with Or Lluewhyn Excel 6 02-17-2017 10:48 AM
Sumif with Conditions Haha88 Excel 2 12-21-2016 12:08 AM
Another SUMIF OTPM Excel 6 06-06-2016 03:00 AM
VBA sumif Nisio07 Excel Programming 0 02-26-2016 07:53 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:14 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