Using an Array?

[andrewb90]

Hello all,

I have this formula that I am starting to use however, I think an array formula maybe easier to do, unfortunately I am not making it work so I am hoping for some assistance.

Here is my current formula so far:

=(((MOD(F89-E89,1)*24)*T89)+((MOD(F90-E90,1)*24)*T90))/$E$85

The MOD sections I need to go all the way through row 180, but I don't want to make this formula so long. The entire formula will be divided by E85.

Thanks,

Andrew

 

[Aladin Akyurek]

It should be:

=SUMPRODUCT(MOD(F89:F90-E89:E90,1)*24*T89:T90)/E85<strike></strike>

 

[andrewb90]

even better! thank you!

 

[Aladin Akyurek]

even better! thank you!

You are welcome.