Counting total based on Status & Date

leah cattarin · 03/20/19

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

please help.png

Paul Newcome · 03/21/19

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>DATE(2018, 6, 30), @cell<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 · 04/03/19

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

Paul Newcome · 04/04/19

Happy to help!

Counting total based on Status & Date

Comments

Help Article Resources

Categories