Home |
Search |
Today's Posts |
#1
|
|||
|
|||
sumif issues
Hi
I am taking an online class with basic excel 2010 functions/formatting etc.. and I noticed this issue: the worksheet for the class has a list of employees and data - salary, names, id, gender etc... on the second sheet you learn to use sumif fxn.. so if you do it this way: sumif(range,criteria, [sum range]) where range is the chosen by click/dragging the cells - you get one value IN this instance we are calculating salaries of folks in "clerical" department. HOWEVER.. the same function returns totally different numbers when you NAME the columns and use names instead of the same ranges when click/selected -- how can this be??? don't know if one can upload a sheet here.. but would be glad to do so so you could see the issue?? |
#2
|
|||
|
|||
Quote:
If it's easier, feel free to email it to me on pubnut @ gmail . Com (without the spaces) and I'll have a look at it from there. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumif issues
"jeffm70" wrote:
don't know if one can upload a sheet here.. but would be glad to do sov so you could see the issue?? Yes, we need to see the Excel file, unless you want to take the time to explain the situation better. (Specific formulas, cell references, etc.) You can upload an example Excel file (devoid of any private data) that demonstrates the problem to a file-sharing website and post the "shared", "public" or "view-only" link (aka URL; http://...) in a response here. The following is a list of some free file-sharing websites; or use your own. Box.Net: http://www.box.net/files Windows Live Skydrive: http://skydrive.live.com MediaFi http://www.mediafire.com FileFactory: http://www.filefactory.com FileSavr: http://www.filesavr.com RapidSha http://www.rapidshare.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 issues really | Excel Programming | |||
sumif issues over multiple colums | Excel Worksheet Functions | |||
nested sumif or sumif with two criteria | Excel Worksheet Functions | |||
need help for several issues | Excel Programming | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions |