I think you need to give some examples of your data and your expected
results.

Other than that it looks like =A1/4 to me, which I am sure is too
simplistic.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"LA" wrote in message
...
I do not think "sumproduct" would help in this case where annual cost is
in
one cell for one year, how can I divide it into 4 (4 quarter a year) in
the
quarterly column. Is there any other posibble function?
Tks for your response.

"Peo Sjoblom" wrote:

Do you want to sum quarterly based on a column of dates and amounts? If
so
use


=SUMPRODUCT(--(A1:A365=--"2005-01-01"),--(A1:A365<=--"2005-03-31"),B1:B365)

for the date range from Jan 1 to Mar 31

--
Regards,

Peo Sjoblom


"LA" wrote in message
...
Hi all,
I have a yearly cost in a column, I need to create another column for
quarterly cost with the source taken from yearly cost column. Am I
right
to
choose offset funtion in this case and if yes, how to set the correct
one
(especially regarding the "height" in the function criteria).
Any help would be much appreciated.
LA