Discussion split from this thread: ADD A RANGE OF CELLS FROM MULTIPLE COLUMNS BASED ON CRITERIA FROM ONE COLUMN
This formula works in 365? This is good. I'm still in 2016I suggest that you update your Account details (click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)
I also suggest that you investigate XL2BB for providing sample data to make it easier for helpers by not having to manually type out sample data to test with.
Try
Excel Formula:=SUMPRODUCT((F5564:F5568="CC")*EL5564:EP5568)
Last edited by a moderator: