View Single Post
  #3   Report Post  
Bill Ridgeway
 
Posts: n/a
Default

I don't know what a 1040 form is all about so I'll have to do a bit of
guessing.

You need some helper columns
Column A - Your input (a description of the expense)
Column B - Your input (the amount)
Column C - Your input a four character code
Postage & stationery - post
Stock - stoc
etc.etc
Column D - Formula
=IF(c1="post",b1)
Column E - Formula
=IF(d1="stoc",b1)
etc.etc

The totals of each column can then go onto the form.

Regards.

Bill Ridgeway
Computer Solutions

"John Henry" <John wrote in message
...
I wish to sum various categories of tax-related expenses for my accountant
to
do my 1040 and related forms. Can you suggest a simple way to do this
with
Excel? I have never used Excel before now.