angel585858
New Member
- Joined
- Jun 18, 2020
- Messages
- 5
- Office Version
- 2013
- Platform
- Windows
I am trying to sum columns based off of criteria in an adjacent column. The below formula works as long as I have less than 25 different criteria but won't sum anything more than that.
I have 42 different criteria that I need summed. Is there another way to do that?
=SUM(SUMIF($D$1:$D$800,{"M1","M2","M3","M4","M6","M7","M8","M9","MG","MJ","MN","MR","MW","PB","N7","N8","N9","R1","R2","R3","R4","R5","R6","RA"},I:I))
I have 42 different criteria that I need summed. Is there another way to do that?
=SUM(SUMIF($D$1:$D$800,{"M1","M2","M3","M4","M6","M7","M8","M9","MG","MJ","MN","MR","MW","PB","N7","N8","N9","R1","R2","R3","R4","R5","R6","RA"},I:I))