Need help incorporating SUMIF to only calculate positive numbers in the attached sheet

[spittingfire]

Hi All,

I have an attached sheet that calculates totals from now + 1 hour until the end of the day based on the provided data.

The formula works well except I just realized that if negative numbers are included in the data it is also being captured in the totals. I only want the positive numbers to be calculated with the formula. I am aware of the SUMIF formula however I do not know how to incorporate it inside the formula.

Formula that needs to be edited is located in CELL F3.

=SUM(OFFSET(A1,MATCH($J$1,$C:$C,0)-1,1,10000,1))

Any help will be appreciated.

Thanks in advance

[Jonmo1]

Perhaps

=SUMIF(OFFSET(A1,MATCH($J$1,$C:$C,0)-1,1,10000,1),">0")

[mehmetcik]

Try:-

=SUMIF(OFFSET(A1,MATCH($J$1,$C:$C,0)-1,1,10000,1),">0")

[spittingfire]

Thanks Jonmo1 and mehmetcik

That worked perfectly fine

[Jonmo1]

You're welcome.