if a date is X then excel populates a cell?
need a date range between Oct 1 and may 31st to have a cell populate a sum of different cells automatically.
need a date range between Oct 1 and may 31st to have a cell populate a sum of different cells automatically.
Copyright © 2024 Q2A.ES - All rights reserved.
Answers & Comments
Verified answer
Suppose Column A Contains Dates and Column B Values
Paste This Formula
=SUMIFS(B:B, A:A, ">=" & DATE(2013,10,1) ,A:A ,"<=" & DATE(2013,10,31))
Hope this will help you.
(°.°)a