Sum based on values based on number of days

[runeroan]

Hi, is this possible?

A1 has value 200
A2 has value 100

B1 is a date
B2 is another date

C1 is =B2-B1 for number of days

How can I calculate first 30 days with value from A1 + days over 30 days with value from A2 in a total sum?

Anyone? Thanks.

 

[Gerald Higgins]

Hmm . . . pretty vague.

What exactly do you want the results to be, and why ?