=SumiF & =Countif between two dates, and with code
- or -
Post a project like this1294
£30(approx. $37)
- Posted:
- Proposals: 3
- Remote
- #3007342
- Awarded
Description
Experience Level: Entry
HI,
I have a Excel File that is connected to Azure, which means emailing the file is not possible.
I would like to team viewer, or share screen.
For an Excel expert this is a very simple task and is a quick one.
Task:
The spreadsheet has two tabs.
1. Invoices- a linked data source
2. PW-Support
The invoices tab lists all invoices for the company.
1. We wish to sum the invoices, that have a certain code/ label AND are between two dates.
2. We wish to Count the invoices, that have a certain code/ label AND are between two dates.
We then wish to replicated this for all months in 2020, including months in the future.
Please see my attempt in the image attached.
I have a Excel File that is connected to Azure, which means emailing the file is not possible.
I would like to team viewer, or share screen.
For an Excel expert this is a very simple task and is a quick one.
Task:
The spreadsheet has two tabs.
1. Invoices- a linked data source
2. PW-Support
The invoices tab lists all invoices for the company.
1. We wish to sum the invoices, that have a certain code/ label AND are between two dates.
2. We wish to Count the invoices, that have a certain code/ label AND are between two dates.
We then wish to replicated this for all months in 2020, including months in the future.
Please see my attempt in the image attached.
Simon L.
100% (11)Projects Completed
7
Freelancers worked with
6
Projects awarded
40%
Last project
5 Dec 2023
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies