Microsoft Office Questions? Ask a IT Expert for Support ASAP
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.
Thank you for the sample file. Please give me a moment to check it
Can you please tell me which specific cell or column are you referring to or where the SUMIF formula is located?
For instance, E4 where the SUMIF formula is stored, is showing the result as 14. Is it wrong? What is your expected result for E4 then?
Ok. Please give me a moment to check
No, I do not provide phone support. I am checking your file now
You are saying G24 should be 0. It is now. But it is not using SUMIF formula.
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.
Thank you for using our service.
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?
ok, you will need to run me though this again.
you want to get both counts and sums. Which column do you want to get the counts or sums of based on the criteria?
Hi there, I am looking at this now for you.
But one thing, if you sumif on 0 you get 0 as its summing 0
Do you mean countif ?
To count how many times it appears?
ok, I have looked at it but a little confused as you want to sumif on 0 and 000 ect but this will always return a 0
Or are you saying to sum the column next to it if it has 00 ?
no its no possible as your summing 0
0+0 will always = 0
even 00000+00000 = 0
As your only adding 0
There is no way to get around this, it is not a limitation of Excel it is maths.
If you would like any additional information or assistance, please do not hesitate to let me know.
And please take a second to rate my service by clicking one of the stars at the top of the screen then submit