Why does sumifs return value

Search forums. Log in. Install the app. If you forgot your password, you can reset your password. JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding. You are using an out of date browser. It may not display this or other websites correctly. You should upgrade or use an alternative browser. Thread starter Melimob Start date Dec 1, Melimob Active Member.

Joined Oct 16, Messages Hi I'm going cross eyed looking at this. Regards Kevin Merged Cells They are the work of the devil!!! I am using Excel The original spreadsheet was a and has been updated through the years. Can you just post the formula? Audere est facere. OK: this is the spreadsheet below. The above is shown in figure below; Any help would be highly appreciated. This thread is locked. You can follow the question or vote as helpful, but you cannot reply to this thread.

I have the same question Report abuse. Details required :. Cancel Submit. Previous Next. Perhaps you were after sums by row and column, which you can achieve with simple SUM formulas. How satisfied are you with this reply? Thanks for your feedback, it helps us improve the site. Rajesh C. Amit Tandon. The information is in one workbook and I have started from scratch so I know the formula should work. Any help would be appreciated: The Data Input Tab contains all information needed for the report.

When the criteria is used, one of the values from the corresponding range provides the other argument. If you are putting the criteria in a cell, which you reference from the function as you are doing in your post , you simply put the criteria in the cell, typing it as shown. Theoretically, if you are simply looking for a match to a constant value that is, your half-expression begins with an equal sign , you can just put in the value; so using just the number should work.

On the other hand, in many cases — particularly when you are entering the criteria directly in the function — you will want to enclose the criteria in quotes. Perhaps you could try reducing the ranges. Another step I might take is to try removing one of the criteria and the associated range.

No Account?