Counting total based on Status & Date

leah cattarin

Hi,

I'm trying to calculate the total value of all the won job in this financial year. I have to reference 3 columns for this (Date submitted, Value, Status) not sure how to make the formula. 

This is as far as I got. Please help. 

=SUMIFS([Tender Due]:[Tender Due], >DATE(2018, 6, 30), <DATE(2018, 6, 30), Status:Status, "Won") + Value:Value

Paul Newcome

Give something similar to this a try, but you are going to have to edit some portions. I will specify those below the formula.

 

=SUMIFS(Value:Value, [Tender Due]:[Tender Due], AND(@cell&gt;DATE(2018, 6, 30), @cell&lt;DATE(2018, 6, 30)), Status:Status, "Won")

 

Your two dates are the same. You are basically looking for any dates that are NOT 6/30/18 if you go by what is written here. Once you correct the dates, this should work for you.

leah cattarin

It WORKED!!! You are an absolute life saver, thank you!

Paul Newcome

Happy to help!