Sumif???

K

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
 
F

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?
 
K

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use TODAY() function as the criteria in a SUMIF formula 1
SUMIF evaluating blank DATE data 2
Sum data using sumif 3
Lessons from optimizing a slow spreadsheet 2
Need help with Excel Formula for calculating sum of products depending on criteria 3
Sumif using partial string 7
SUMIF with multiple columns in sum range 3
Averageif Calcs 6

Top