View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
barry28 barry28 is offline
external usenet poster
 
Posts: 3
Default formula calculation

I would like to know if it is possible to have a formula to calculate the sum
of all entries if they are posted in different rows so that you do not have
to do a data sort.
for example i have simple worksheet like
column a date column b item column c total cost column d tax colimn e nett
cost
I enter as the Invoice comes in and I want to total all the invoices for the
month e.g jul and put total in column f
and then aug in coulmn g etc

Is this possible without doing a data sort
Thank you for your help
--
bary28