Sumif???

[KellyMcG03]

Okay I have a formula now that I am using to calc. the Year-to-date
point will be deleted. "=SUM(EDATE(B8,12)+10"

I want it to only calc. if there is a point value >0 in D.

So I would use Sumif but Im not quite sure how to nest that together

 

[Frank Kabel]

Hi
still not very clear what you're trying to do. Try to post some data
rows (plain text - no attachments please) and describe the expected
result based on this data. Your formula currently sums date values?

 

[Ken]

Kelly,
Are you looking for something like:

=IF(D8>0,EDATE(B8,12)+10,"")

If D8 > 0 then use EDATE function, else leave the cell
blank.