Sign in to join the conversation:
I am trying a SUMIFS formula without much success. The formula needs to return the Distance if Completed Date is before 31/03/20 and Signs has been ticked/checked.
Distance (number)
Completed date (date)
Signs (checkbox)
Is this possible?
Thanks
Faz
It is and the following works:
SUMIFS(Distance:Distance, [Completed Date]:[Completed Date], <DATE(2020,3,30), Signs:Signs, 1)
Does it work in your case?
Hi Chakm, I'm afraid not - it says #UNPARSEABLE
Hi Faz,
Chak's formula should work. Try my second one and see if that works.
Try something like this.
=SUMIFS(Distance:Distance; [Completed Date]:[Completed Date]; <DATE(2020; 3; 30); Signs:Signs; 1)
The same version but with the below changes for your and others convenience.
=SUMIFS(Distance:Distance, [Completed Date]:[Completed Date], <DATE(2020, 3, 30), Signs:Signs, 1)
Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.
Did it work?
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
I re-did Chak's formula and it worked. I think the issue was because the column was labelled Distance (miles) - the extra brackets were probably confusing the formula. Column renamed (without brackets ).
Thanks so much Chak (and Andree too).
Excellent!
Happy to help!
Andrée
Hello, I face one difficulty trying to transform text in date using DATE formula I want to find the first day of a week based on the week number & year number put in a cell For instance in a cell I find "25-45" FOR Year= 2025 & Week= 45, so I look for the monday of this week that should be the 3rd of nov Step 1 find first…
I have a formula that I have used for years on a sheet and it was working an hour ago and then all of a sudden it just stopped working, I went out the sheet and back in and . The formula is =IF([Shop Order]@row = 0, (COUNTIF((RN:RN), RN@row ))) but instead of returning the value it says #INVALID COLUMN VALUE Got it working…
Hi Everyone, Looking for some assistance on a dashboard report issue I am running into. I have a dashboard with 3 reports added as Web Content. All 3 reports use at 1 common sheet. All 3 reports are published as read only. Users are not shared the underlying sheets. All 3 reports have some form of filtering. 2 of the…
