From the information you've given so far, I see no need to use VBA. Assuming
your temperatures are in column B, your DDF formula is
=SUMIF(B:B,"0")
You can then multiply this by your metlfactor and area (let's say they are
in cells C2 and D2 respectively)
=SUMIF(B:B,"0")*C2*D2
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"thehigh_23" wrote:


Hi
For a project I am doing university I need to produce a basic ice melt
model. I have got hourly temperature data for a whole year from a
certain location and area data from a glacier I am looking at, which
has been broken down to several elevation bands each containing the
area of ice present in that band.
Basically I need the model first to calculate the sum of postive
degrees for each day of the year (so this would add together all the
temperature data above 0 for each day). This would leave me with 365
postive degree day factors (DDF).

Each of these DDF's then need to be multiplied by a Meltfactor (say
0.06) and then multiplied by the area of a selceted elevation band
(DDF x 0.06) x Area

I am still a bit of a novice when it comes to all things excel so Im
struggling a bit with this one. Its been suggested that I should use
VBA but to be honest i dont know where to start. Any useful tips etc
would be much appreciated.

Cheers
Ryan




--
thehigh_23