Why does sumif return 0

Excel Facts. Click here to reveal answer. Excel Formula:. Click to expand You must log in or register to reply here. Similar threads D. Replies 2 Views Oct 29, derickj. Question Need unique rows displayed based on car no. Miloni Jul 21, Excel Questions 2. Replies 11 Views Jul 27, Toadstool. Sep 14, Phuoc. Question Help With 2 Formulas. What did I set-up incorrectly in this formula?

BruceWayne Your criteria is an entire column which may be throwing it off. B2:B — IcyPopTarts. Add a comment. Active Oldest Votes. B:B And copy down. Scott Craner Scott Craner k 9 9 gold badges 42 42 silver badges 74 74 bronze badges. What do you mean inflated? For example, for the first 4 this is what is returned using your formula - but if I do a filter and manually sum, they return 1, 4, 8, 10 — IcyPopTarts.

This formula returns the total sum in one cell not line by line totals. You need to provide test data and expect outcome. Show 1 more comment. Add solver. Add sort-filter. Add sparklines. Add statistical-analysis. Add table. Add text-manipulation. Add user-defined-functions-udf. Add views. Add vlookup. Add workbook-settings. Add worksheet-settings. Clear Vote. D2:D27 is returning 0. Any idea why this is happening? MS Office Version: Answer Discuss. Dr Liss Please attach the workbook you are referring to and before solutions are suggested explain if the data in B2:B27 is imported as in some of your previous questions.

Post Cancel. Add to Discussion. Selected Answer. Did you solve this separately? Asif Good that you may have a solution but for future reference, please note that your statement above isn't an Answer i. You'll see that I already asked the user for the workbook yesterday, see Discussion attached to the Question.