SUMIF(MID(A9:A500,5,1),Z,C9:C500)
Whats wrong in my formula above? I am trying to add columns Data 1-4 separately if the mid letter is Z. The name has 4 numbers in the front and 2 at the end
Total sumif sumif sumif sumif
Name Data1 Data2 Data3 Data4
####AAL## 4,300.75 5,569.46 (1,268.71) 8,107.53
####ABR## 330.00 22.30 330.00 44.99
####ZDB## 10,226.50 33.00 10,226.50 12.29
Thank you in advance for your help!
=SUMIF(RangeOfThingsToBeExamined,CriteriaToBeMatched,RangeOfValuesToTotal)
The structure of a =MID() is:
=MID(OriginalText,PositionToStartPicking,NumberOfCharactersToPick)
Can a =MID() statement be a Range?
Try this:
=SUMIF(A2:A4,”*Z*”,C2:C4)
MIKE
http://www.skeptic.com/