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
Set up data transfer from the Meta ads cabinet to Google Sheets
27 USD
Hello, I have a ready reporting table for my project. I need to set up automatic data transfer from the Meta ads cabinet to a Google spreadsheet for the following parameters: - budget for all campaigns Amount Spent - number of clicks - Clicks - number of checkouts - Initiate… Information Gathering, Data Processing ∙ 1 hour 33 minutes back ∙ 9 proposals |
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 ∙ 5 hours 19 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 ∙ 6 hours 33 minutes back ∙ 6 proposals |
Macro for sorting a table in Excel
56 USD
There is a table with data, which has a column - Client and other columns. The macro for the client column activates the filter, selects the first value from the list - "Client1". It copies the filtered data, creates a new Excel file in the specified folder, names it Client1,… Data Processing ∙ 1 day back ∙ 27 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 2 hours back ∙ 10 proposals |