formulas in Excel

F

foust

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.
 
J

Jim Rech

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
| 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.
 
Top