Sign in to join the conversation:
I have -
a column containing start dates, that spans 2019
a column containing an assortment of names that re-occur on a random basis.
I want to count how many times each name occurs each month.
Any help appreciated!
Hi Amanda,
Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
Try something along the lines of...
=COUNTIFS([Name Column]:[Name Column], "Name", [Date Column]:[Date Column], IFERROR(MONTH(@cell), 0) = ##)
Replace the column names with yours and replace the ## with the appropriate month number, and this should work.
Thank you!
Happy to help.
A colleague of mine and I used to use the row menu "send" option with years of success. It would email the row data to an email address of our choosing, but it no longer works. A couple of new interns we hired use the option with 100% success. I have tried all of the solutions found online and have not found a solution.…
Is there an option a sheet that forces a person to complete the information in the cell? or will not let the person go the next cell without completing the one before?
is it possible when adding photos in the attachments for a row, can the image be a photo scanner capability? we have equipment that has bar codes on the boxes, instead of taking photos, is there an option for a bar code scanner and upload the information from the bar code ? or another example - like a VIN tag inside a…
