Thread: Sumif
View Single Post
 
Old 11-05-2019, 07:57 PM
Karen615 Karen615 is offline Windows 7 64bit Office 2010 64bit
Advanced Beginner
 
Join Date: Jun 2011
Location: Chicago
Posts: 76
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