Sign in to join the conversation:
Hello,
I'm trying to sum numbers in a column a if the launch date is within the next 30 days. Thanks in advance for any help!
Try something along the lines of...
=SUMIFS([Column A]:[Column A], [Date Column]:[Date Column], AND(@cell >= TODAY(), @cell <= TODAY(30)))
It will sum column A if the date is between today and the next 30 days.
thank you!
Happy to help.
I am trying to get the passenger count per month per year, and I can't seem to get the formula correct. I need to add the number of passengers for each month per year. If anyone could assist me with this, I would greatly appreciate it. Thanks!
I need to edit a large sheet that has a lot of predecessors. I need to delete one row and move another. when I make the changes the predecessors for proceeding lines are not correctly displaying the dates correctly. Need help.
Hi all, I'm having some issues with an index-collect formula. I have (3) existing sheets that list a unique project name (text field), as well as a producer assigned to work that project. The producer column in all (3) sheets is set as a contact field. In a separate sheet, I'm trying to auto-populate the producer…
