Thread: Sumif
View Single Post
 
Old 11-06-2019, 06:52 PM
Karen615 Karen615 is offline Windows 7 64bit Office 2010 64bit
Competent Performer
 
Join Date: Jun 2011
Location: Chicago
Posts: 112
Karen615 is on a distinguished road
Default

I'm soooo sorry. Not sure what I was thinking when I wrote this.

So the values would be:

A's=100
B's=75
C's=50
D's=25


In the A3:A100 range, I would have 25 A's, 25 B's, 25 C's and 23 D's.

So all of that would equal

A=2500
B=1875
C=1250
D=575
--------
6200


What would the syntax for the formula be to yield the sum of 6200?


Thank you
Reply With Quote