# nested mid in sumifs

May 11, 2017 at 21:23:57
Specs: Windows 7
 =SUMIF(A2:A4,"????Z*",C2:C4)in the above formula I want to sum of the locations all having 4 digit text i.e. 1200, 2450, 3360, 7600, 4600I tried following formula for locations who has 6 as its second digit but not working=SUMIF(A2:A4,"?6??",C2:C4)

See More: nested mid in sumifs

#1
May 12, 2017 at 06:54:58
 =SUMIF(A2:A4,"?6??",C2:C4) works for me as long the referenced cells contain 4 characters and is recognized as a text string. e.g.A624A6bb'1624 (The apostrophe forces the number to be a text string)However, I'm confused by your post. Are you asking 2 different questions or is your second formula somehow related to your first?Your first formula works for value that have a Z in the 5th position yet you say you want it to sum locations that contain 4 digit text strings. Why do you have the Z* in the formula?It might help if you posted an example of your data along with the expected results. That way we would know exactly what you are working with and exactly what the result should be.

Report •
Related Solutions