Home |
Search |
Today's Posts |
#1
|
|||
|
|||
formulas in Excel
eI am working with a speadsheet that I need to caculate the difference of two
number by earnings code. I tried using sub-totals but each code has a different formaula, I cannot sort by codes because I have to sort by employee. I found that I was subtotaling by employee coping the formaula for the codes that use the same formaula but then doing the others manually. Does anyone have any suggestions? Sorry if this is confusing-- I'm dealing with over 90,000 rows of data. |
#2
|
|||
|
|||
formulas in Excel
If you need sums by earnings codes have a look at the SUMIF function in
Help. Then you can subtract the result of two SUMIFs to get the difference between the totals of two earnings codes. -- Jim "foust" wrote in message ... | eI am working with a speadsheet that I need to caculate the difference of two | number by earnings code. I tried using sub-totals but each code has a | different formaula, I cannot sort by codes because I have to sort by | employee. I found that I was subtotaling by employee coping the formaula for | the codes that use the same formaula but then doing the others manually. Does | anyone have any suggestions? Sorry if this is confusing-- I'm dealing with | over 90,000 rows of data. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing Excel Formulas without file paths updating | Excel Discussion (Misc queries) | |||
Simple formulas in existing Excel 2002 no longer working. | Excel Worksheet Functions | |||
Help, Urgent Excel Formulas are not calculating | Excel Discussion (Misc queries) | |||
I want Excel to allow cells with formulas and unrelated text | Excel Discussion (Misc queries) | |||
Problems with Excel formulas when 2002 upgraded to XP | Excel Worksheet Functions |