Writing the formula in Google Sheet
You need to write a formula that will contain COUNTIF and SUMIFS and summarize the value from the letter, according to the criterion the value of the cell is empty value.
More detailed description of the task in this page: https://www.awesomescreenshot.com/video/24060702
The formulas that I show in the video:
=ARRAYFORMULA(IF(A11"";COUNTIFS('SM'!F:F;"="&A11;'SM'!O:O;">="&$B$1;'SM'!O:O;"="&$B$1;'SM'!O:O;"
Client's review of cooperation with Oleksii Kuzavov
Writing the formula in Google SheetI highly recommend the executive. It’s all very fast and quality.
Freelancer's review of cooperation with Petr Kyshenya
Writing the formula in Google SheetEverything is OK
The customer is always in contact, clear tz, timely payment.
I recommend it.
-
274 2 0 Welcome to! Ready to take your project. Get to discuss further details!
-
345 22 0 Good day . There is great experience. Unfortunately, the video does not allow you to watch. We can talk separately. Turn to
-
3621 113 7 1 Welcome to.
I have a great experience working with Google Sheets and Excel.
I also do scripts for the above-mentioned programs, I write parsers on python.
I’ve done similar projects, there’s a solution.
Look at the portfolio and reviews.
Get acquainted with the project. Ready to help with the implementation.
Let’s talk about the details.
Current freelance projects in the category Data Processing
Assistance with personal social media, networking, and projects for a monthFor activities in the field of science and scientific publications, I am looking for an assistant to perform basic organizational and operational tasks for a month as an executive assistant. Tasks include, but are not limited to: - working with AI at a deep level with documents… Data Processing, Customer Support ∙ 11 hours 35 minutes back ∙ 7 proposals |
Translate the file and tracker in NotionTranslate/create an identical tracker in Notion into Ukrainian. Intro slide (translate only what is in the screenshot) https://freyadesigns.notion.site/Deep-Work-OS-Template-2cae6bb55a4e809aaed2c97548e64828 Tracker - translate everything (except the footer)… Data Processing ∙ 12 hours 49 minutes back ∙ 7 proposals |
Setting up and updating dashboards in Looker StudioWe have several dashboards created in Looker Studio that pull data from main Google Sheets.Last year, we regularly maintained and updated these sheets; however, the process was later halted, and the specialist who was managing the system no longer works with us. Currently, some… Data Processing ∙ 1 day 9 hours back ∙ 10 proposals |
Database of hotel owners Ukraine
67 USD
Could you please let me know if you can match a database or find hotel owners in Ukraine for lookalike audiences? Perhaps someone has it and what is the price? Thank you Data Processing, Information Gathering ∙ 7 days 12 hours back ∙ 20 proposals |
Analytics Setup
223 USD
We have GTM and Conversion API connected to Meta. Currently, it is not working correctly everywhere. We need to fix the issues and further develop the amount of analytics on the product. Data Processing ∙ 8 days 5 hours back ∙ 18 proposals |