Hi, welcome and thank you for your question. My name is ***** ***** I am glad to assist you today.

I am very sorry about your issues. Can you please send me a sample of your Excel file data so that I can check from my end to see what causes the problem? You can use the Add Files button to attach a sample file in your reply. Please let me know by replying to me here so that I can help you further.

E24 COUNTIFS($F$138:$F$100000,"000",$D$138:$D$100000,"1",$E$138:$E$100000,"<=4")..... The answer should be 0 because I only want to count "000" if column D has a 1 in the below cells. If it helps to talk, I'm open to phone conversation

I am very sorry, but I am running out of time and I cannot continue to help you with this. I am signing off now so please allow me to opt out so that my fellow experts who are available now can assist you further. You will be notified when another expert joins you here.

if you are trying to sumif column D, if the value is 000 unfortunately that will not work. The numbers are stored as text and excel cannot sum text. It works the same for lookups, if numbers stored as text it cannot be looked up. If you convert to number then it would become a 0 which would be the same as other 0, so that might not work for you.

What exactly is your goal, what are you trying to accomplish?

so if it contains that value in column D. Inother words it is "000", "000a", "b000", "a000b","0000001" those would all get summed, and you are trying to sum column E?

but In Column E, I'm trying to countif not sumif "if they meet the criteria of having a 1 in column d". In column G....I'm trying to sumif based on Column E.

I am trying to sumif Column G first. I would like to add all "000"(G24) units together based on the sizes in column E. Sum all "00" (G25)units and "0"(G26) units separately

Customer:replied 8 months ago.

To make it plain and simple. Refer to the calcs in all sizes excluding the leading 0 sizes. I'm trying to use the same calcs in the column but I can't figure out how to do it with 0000