Improve COUNTIF Formula in Excel

$10-30 AUD

Imekamilika

Imechapishwa

over 5 years ago

$10-30 AUD

Kulipwa wakati wa kufikishwa

Need to include logic to existing formula in column AD in attached spreadsheet, where if a horizontal cell in column AC is >61, then to reset my COUNTIF formula in column AD to 0, otherwise leave as is

Excel

Kitambulisho cha mradi: 18661792

Kuhusu mradi

14 mapendekezo

Mradi wa mbali

Inatumika 5 yrs ago

Unatafuta kupata pesa?

Barua pepe

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa

Pata malipo kwa kazi yako

Eleza pendekezo lako

Ni bure kujiandikisha na kutoa zabuni kwa kazi

Imetolewa kwa:

@MimiFL

Hello, i believe this can be solved by applying another if statement. IF you are interested in working with me, please message me so i can ask a follow up question and i believe i will solve this in matter of minutes. Thanks, Milan

$10 AUD ndani ya siku 0

5.0

(526 hakiki)

7.1

14 wafanyakazi huru wana zabuni kwa wastani $19 AUD kwa kazi hii

@Khurramz

Hello Gumby13! I can edit the formula and send you asap. Please initiate chat so that I can attach the file and send to you. Thanks Khurram

$15 AUD ndani ya siku 1

5.0

(361 hakiki)

7.5

@citijayamala

1. I am an expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex markets. Experienced MBA Finance as well. 3. Your project will be delivered on time with high standard 4. Assistance will be provided with number of clarifications until client satisfaction

$50 AUD ndani ya siku 1

4.7

(67 hakiki)

5.7

@KozlouAlex

Hello, My recent Excel Work is below. https://www.freelancer.com/projects/project-18646362/ Will send you formula during 30 min max

$30 AUD ndani ya siku 0

5.0

(26 hakiki)

4.5

@anachirilov7

Hi! My name is Ana and I'm interested in your project. I have good experience in excel projects and pay attention to detail. Write me, I will send you result already.

$20 AUD ndani ya siku 1

5.0

(13 hakiki)

4.3

@zaahidali61

Hi Next Employer, I am interested in your project. I hold master degree in Business Administration (Finance). I am experience data entry operator accountant and auditors having more than 9 years’ experience of data entry Microsoft Word, Excel Power Point and web scraping. I hope will be hear positive soon from you side

$23 AUD ndani ya siku 1

4.6

(14 hakiki)

4.1

@naveenwasala

Dear Sir, I'm an engineering student. Trust me. I'll do my work in my best. Hope you will be happy about my performance. Thank you!

$10 AUD ndani ya siku 1

0.0

(0 hakiki)

0.0

@robin28rock

This Excel task is most suitable for me as I have more than 5 years of experience in Data processing and manipulation. Skills: Advance level Excel intermediate in Python and SQL

$15 AUD ndani ya siku 1

0.0

(0 hakiki)

0.0

@yashkelkar09

I am an electronics engineer and a digital marketer very well versed with excel from last 10 years. Try me once to let me prove my worth.

$10 AUD ndani ya siku 1

0.0

(0 hakiki)

0.0

@lazarusjm

Hi mate. I have a fair bit of excel experience. Should be easy to fix with an 'if' statement into column AD. Jake.

$15 AUD ndani ya siku 1

0.0

(0 hakiki)

0.0

@arlupywidowati

I have read your posted job details and I am very interested to work on this project. I am ready to give you hardworking, flexibility and honesty. I can work with minimal supervision, communicate and give updates on the status of my work output.

$10 AUD ndani ya siku 1

0.0

(0 hakiki)

0.0

@gorapwr

Hello, here i will add the formula that does what you need Here is the one that you have: =COUNTIF($A16:A$548,A16)-1 This is the one that you need: =IF(AC16>61,0,COUNTIF($A16:A$548,A16)-1) Hope you pick my bid thanks you, if not well here you have your solution.

$10 AUD ndani ya siku 1