Find Jobs
Hire Freelancers

VBA loop code to sum

$10-30 AUD

Concluído
Publicado há mais de 7 anos

$10-30 AUD

Pago na entrega
Hi, I am looking for some VBA code to sum some data for me. I have attached an example file for you, with each months solution in column D. To explain what I need, I have a data set in Excel that contains dates in column A, a description for each date in column B, and an amount for each item in column C. I need the VBA code that sums the amounts, and provides the total for each 'Daily Amount' for each month, including the 'Monthly Amount' for the 1st day of the next month. To explain, I need it to sum all 'Daily Amounts' for January 2017 and include the 'Monthly Amount' on the 1st February 2017, which creates a total for January 2017. The February total would then be the sum all 'Daily Amounts' for February 2017 as well as the 'Monthly Amount' on the 1st March 2017, and so on. The VBA code will need to have the following functionality: - the VBA will need to be a loop, as the amount of rows could be very large - sum only the amounts that have the description 'Daily Amount' and 'Monthly Amount', and ignore any other description amounts. I have included some extra data with the description 'Ignore this', this data should not be included in the sum - there may be any number of 'Daily Amount' figures for each day, for example there may be 3 'Daily Amount' for the 20th of February - there may be any number of 'Monthly Amount' figures for each day, for example there may be 3 'Daily Amount' for the 1st of February - the number of dates each month will change each month, and wont be a set number of dates - some months there may be no 'Monthly Amount' on the 1st to include (i.e. only 'Daily Amount' figures should be summed for this month) - some months there may be no 'Daily Amount' figures, and only a 'Monthly Amount' figure Can the sum of the 'Daily Amount' figures for each month, along the 'Monthly Amount' on the 1st of the following month, be provided in column E for each month please? For example, can the sum of the January 'Daily Amount' figures, and the 1st of February 'Monthly Amount' be listed in column E on the 1 Feb 2017 line, thank you Kind Regards
ID do Projeto: 13162173

Sobre o projeto

2 propostas
Projeto remoto
Ativo há 7 anos

Quer ganhar algum dinheiro?

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
Concedido a:
Avatar do Usuário
$30 AUD em 1 dia
4,9 (12 avaliações)
3,0
3,0
2 freelancers estão ofertando em média $30 AUD for esse trabalho
Avatar do Usuário
I know what do you want and i have more skill about your project. So contact with me about your project done in time with your budget.
$30 AUD em 1 dia
5,0 (1 avaliação)
0,5
0,5
Avatar do Usuário
We are highly experienced Post Graduate Engineers, Doctors, IT, ITES, Software, Infrastructure Professionals, Web Designers and IT Architects. We can redo, improve, and publish any engineering, scientific MATLAB, SIMULINK, PSPICE, NS2, NS3 based IEEE papers. We can give remote support in Wintel, ADS, Unix, Storage, Backup, Network, Security tracks. Have experience in Active Directory, DNS, DHCP, FTP, IIS, SharePoint, CRM, SQL, WDS, ADRMS,ADFS,ADLDS, SCCM, Citrix Xenserver, Citrix XenApp, CRM,CRM Outlook connector IFD, Linux, Apache, My SQL, Postfix, VM Ware, Vcenter, VCO, VOIP (3CX)WHM, cPanel, H-Sphere, Hosting Controller, Plesk, DirectAdmin based web hosting support. We work in PHP, JAVA, ASP, DOT NET, Prestashop, Magento, woo commerce, OSCommerce, WordPress, Joomla, Web Hosting Panels Programming, LAMP, Android java development, Backend Server APIs, Android, Java, C/C++, Linux, PHP, MySQL, AJAX, JavaScript, C#, Visual Basic, PHP, MS SQL, My SQL, PHOTOSHOP, CSS, Bootstrap, HTML, JQUERY, JAVA, SCRIPT. We specialize in business, technical, academic, commercial, fiction, and Blog Writing, Dissertations, Academic papers, eBooks, Fiction, Sci-Fi thriller, Technical content, Articles, Web content, and blogs
$100 AUD em 1 dia
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
i have done similiar project and i understand what you need.
$20 AUD em 1 dia
0,0 (0 avaliações)
0,0
0,0

Sobre o cliente

Bandeira do(a) AUSTRALIA
Sydney, Australia
5,0
8
Método de pagamento verificado
Membro desde fev. 16, 2017

Verificação do Cliente

Obrigado! Te enviamos um link por e-mail para que você possa reivindicar seu crédito gratuito.
Algo deu errado ao enviar seu e-mail. Por favor, tente novamente.
Usuários Registrados Total de Trabalhos Publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Carregando pré-visualização
Permissão concedida para Geolocalização.
Sua sessão expirou e você foi desconectado. Por favor, faça login novamente.