You may check the help for the SUMIF formula, it comes with some examples
that you may use.
Other option is to use SUMPRODUCT, there are many examples on the newsgroups
for its use with logical conditions, that may fit on what you need.

Hope this helps,
Miguel.

"Wendy" wrote:

> Hi
>
> I have a spreadsheet with 4 columns Site ID, AccountN, Date of Order and
> Balance.
>
> I have been asked to total the balances based on various date ranges and put
> them on a new totals sheet. I haven't a clue how to do this. Can anyone
> advise please?
>
> Thanks
>
> Wendy
>
>
>