Đã hoàn thành

Convert Googlesheets formulas to only count/sum for THIS MONTH instead of all time

Convert Googlesheets formulas to only count/sum for THIS MONTH instead of all time

Example formula:

=IFERROR(COUNTIF(UNIQUE(Solds!C:D),C2))

This formula would need amending to only count if a new column B was in THIS MONTH.

I would also need the same formulas amending for specific months (or maybe a list of months and years)

On acceptance I will email you a list of the formulas which need changing. This needs to be done today.

Kĩ năng: Excel

Xem nhiều hơn: 500 per month spare time, month full time, outsource month full time, hours month full time job, month part time certificate programme capital markets cpcm, month part time job, 200 dollars month part time, sum time excel, average hours per month full time work

Về Bên Thuê:
( 23 nhận xét ) Stoke-on-Trent, United Kingdom

ID dự án: #9331133

Được trao cho:

archanaoswal

I have written JavaScript code (macros) for Google sheets many times before as seen in my portfolio. I can complete the task today itself

$25 USD trong 1 ngày
(69 Đánh Giá)
5.5

26 freelancer chào giá trung bình$23 cho công việc này

Khurramz

So, you need to apply formulas to filtered (only current month). Right ? .

$24 USD trong 1 ngày
(349 Nhận xét)
7.3
priyal1997

Dear Sir/Madam, I'm happy to help you on this task. I am an expert in advanced excel skills and have a strong financial background. I can do this task within few minutes. Awaiting for your feedback. Best regards, P Thêm

$30 USD trong 1 ngày
(184 Nhận xét)
6.7
ZedExcel

Hello, Please accept my bid on your project. I know exactly what to amend in your formulas and can have the project completed within a short time. Looking forward to a successful bid and working with you. Regards.

$30 USD trong 0 ngày
(31 Nhận xét)
6.6
DeepSyaal

Lets start. Having a team of Professionals. We provide high quality work with accuracy. Would you like to discuss more about your current requirements?

$30 USD trong 1 ngày
(198 Nhận xét)
6.4
kevivu

Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 55 projects, almost 45+ are complex VB/VBA projects, hence i can definitely deliv Thêm

$30 USD trong 0 ngày
(70 Nhận xét)
5.7
SyaalAssistant

Lets start dear provider, Having my own team of professionals and we provide 100% high quality work within given time frame. Would you like to discuss more ?

$20 USD trong 1 ngày
(35 Nhận xét)
4.3
magentapowa

A proposal has not yet been provided

$20 USD trong 1 ngày
(28 Nhận xét)
4.2
imhamzaabbas

I have the all skills required to complete your project, not only I'm skilled but also experienced for this work just need a chance to prove myself.

$15 USD trong 0 ngày
(0 Nhận xét)
0.0
tajweryaqoob

A proposal has not yet been provided

$25 USD trong 1 ngày
(0 Nhận xét)
0.0
oluwaseyi95

A proposal has not yet been provided

$25 USD trong 1 ngày
(0 Nhận xét)
0.0
charinaraisatan

A proposal has not yet been provided

$25 USD trong 1 ngày
(0 Nhận xét)
0.0
Harun2401

Hello, I am advanced excel user. I am ACCA by profession and looking establish my career as freelancer. If you consider me suitable for this project then kindly contact me.

$25 USD trong 1 ngày
(0 Nhận xét)
0.0
kkh567839a6d8526

I am Data Entry/Data Processing Expert who knows the value of time, very hard working and always delivers the work on time. My Motive is to make my employer happy without adding additional charges. If you are looking f Thêm

$15 USD trong 1 ngày
(0 Nhận xét)
0.0
fb544eb67b0c780

My first job. I try to learn how it works. My English is bad but I know excel perfectly, and repetitive

$25 USD trong 1 ngày
(0 Nhận xét)
0.0
kapuranni

A proposal has not yet been provided

$40 USD trong 6 ngày
(0 Nhận xét)
0.0
inna1105

A proposal has not yet been provided

$21 USD trong 1 ngày
(0 Nhận xét)
0.0
jeromebories

Hello I can do it for you.. but only if you send it to me in less than 2 hours.. after that i will be out for the rest of the day. .could make it if you want during week end if you could wait Regards Jerome

$10 USD trong 1 ngày
(0 Nhận xét)
0.0
amityadav574

A proposal has not yet been provided

$25 USD trong 1 ngày
(0 Nhận xét)
0.0
devinstark

Hello. I have excellent excel skills that I use to create robust tools and dashboards for clients. Let me know if you have any questions or need any further information.

$22 USD trong 1 ngày
(0 Nhận xét)
0.0
ahmedgamal9780

cheaper , faster , accurate and flexible . If they are just formulas show them to me now . Ahmed is my name

$25 USD trong 1 ngày
(0 Nhận xét)
0.0