完了

Update a Apple Numbers Spreadsheet with Formulas and Functions

Hello,

I am looking who knows Apple Numbers well and could quickly make this spreadsheet work for us.

I need to update a spreadsheet from Google Doc to Apple Numbers because the formulas and functions do not pull through when it was exported.

To do:

1. Tab titled Transactions: Column B, Category. Needs to be connected as a drop-down list to the options on the Tab Categories > Category Name.

2. The Tab titled Profit and Loss needs to be connected to the Transactions tab. So for all columns there needs to be a search function that would find the totals from the Transaction tab for the corresponding items. For example, Revenue> Sales : would need to find a corresponding total amount and the accurate month from the Transactions. (This is a copy of the formula from the google doc : =if(isblank($F7),,SUMIFS(Transactions!$E:$E,Transactions!$B:$B,$F7, ARRAYFORMULA(MONTH(Transactions!$C:$C)),MONTH(G$4))))

If you have any questions, don't hesitate to ask via direct message!

Thank you!

スキル: データ入力, 情報処理, エクセル, PHP, ソフトウェアアーキテクチャ

さらに表示: Hello. I need to come up with a cover design children\ s books 20 pages., Hello i need, Hello i need 90Euro , hello, i need, Hello i need 100$ in NETELLER, i am ready to pay here 160$ in advance !URGENT, Hello! I need a logo , names and phone numbers of hospital employees that i need entered into an excel spreadsheet, i have a book of names and phone numbers of hospital employees that i need entered into an excel spreadsheet, hello i need urgent typist you just have to write in notepad from image i, hello i need to create a logo and a name to put on my clothing brand, hello i need a presentation like this original presentation, hello i need a logo for my site details in private, formulas excel apple numbers, excel convert excel formulas apple numbers, apple numbers convert spreadsheet, apple numbers real estate spreadsheet, apple numbers formulas excel, excel apple numbers formulas, convert microsoft excel spreadsheet apple numbers, convert excel spreadsheet apple numbers format, convert apple numbers spreadsheet excel, convert excel formulas apple numbers, convert excel spreadsheet apple numbers, convert excel apple numbers spreadsheet, convert numbers spreadsheet

採用者について:
( 5件のレビュー ) Ettlingen, Germany

プロジェクトID: #16086730

アワード:

manish1988ag

Hi, I am interested in your project and I would like to know more details. Kindly drop a message so we can discuss. Relevant Skills and Experience I have more then 5 years experience of advance excel such as lookups, もっと

¥2500 JPY 1日以内
(11レビュー)
2.9

17人のフリーランサーが、このジョブに平均¥3047で入札しています

schoudhary1553

Greeting, I have understood your Update a Apple Numbers Spreadsheet with Formulas and Functions task and can do it with your 100% satisfaction. Please ping me for more discussion. Relevant Skills and Experience I ha もっと

¥3200 JPY 1日以内
(252件のレビュー)
7.5
¥10000 JPY 1日以内
(3540件のレビュー)
6.9
¥2500 JPY 1日以内
(326件のレビュー)
6.7
usmanhassan123

mphill in computer science and expert and I can deliver you within your deadline.

¥3000 JPY 1日以内
(28件のレビュー)
5.2
muradeltaher

Greetings! My Name Is Murad And I’d like to be considered for your position. I Would Love To Have The Opportunity To Discuss Your Project Further. Relevant Skills and Experience I Provide certain services : 1. MS Of もっと

¥3500 JPY 1日以内
(40件のレビュー)
4.5
enymann

Hi there, I work in both excel and numbers so I can help. please contact me so we may discuss further details. Regards

¥4000 JPY 2日以内
(レビュー1件)
1.2
rakdapsl

Good knowledge in excel and MS office. Typing speed over 40 and I’ll be able to deliver the project within the deadline. Relevant Skills and Experience Good knowledge in excel and MS office. Typing speed over 40 and I もっと

¥2500 JPY 1日以内
(0件のレビュー)
0.0
venturesoft296

hey,i have most experience staff .i am interested in your [login to view URL] send me a message that we can discuss more. Relevant Skills and Experience web developer android developer database developer and web designing もっと

¥2600 JPY 1日以内
(0件のレビュー)
0.0
¥2500 JPY 1日以内
(0件のレビュー)
0.0
Annpeej

I have very good knowledge of excel tools. Relevant Skills and Experience Statistical analysis Financial reports Data entry

¥1500 JPY 1日以内
(0件のレビュー)
0.0
¥2500 JPY 1日以内
(0件のレビュー)
0.0
raghunandanbetha

Hi i am Raghunandan , Technical guy , I know advanced excel and excel , I can take your project and can be completed by two 2 to 3 days depending on the work. Regards Raghunandan Relevant Skills and Experience Excel もっと

¥2500 JPY 2日以内
(0件のレビュー)
0.0
¥2500 JPY 1日以内
(0件のレビュー)
0.0
mustafaelsawey

A proposal has not yet been provided

¥1500 JPY 30日以内
(0件のレビュー)
0.0
Ellevera2001

i am romel ellivera,i am graduate of information technology, i am performing data entry for 6yrs. and i have an extensive exposure in microsoft excell. i can assure you that i can delivered reports. Relevant Skills an もっと

¥2500 JPY 1日以内
(0件のレビュー)
0.0
¥2500 JPY 1日以内
(0件のレビュー)
0.0