CF cannot return the result of a formula - it can only do formatting based upon specified criteria.
Assuming you want to sum A2:A10 if the date in A1 is 1 July 2017 put this in a blank cell :
=IF(A1=DATE(2017,7,1),SUM(A2:A10),"")
I guess I didn't read his post properlyUnless that is copied down to all cells, and then that range is summed, I dont see how that will work? If A1 does match, it will sum the whole range
That's a little bit different.I am after a formula that sum's all rows in a column (A1:A25) which ever cells in B column state July