Previous Topic Next Topic

Formula calculate daily income in excel

[Closed]
Report
Posts
3
Registration date
Thursday April 3, 2014
Status
Member
Last seen
April 5, 2014
 -
Posts
2819
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 25, 2021
 -
I'm using excel to calculate my income and expense on monthly basis using sum() but I need to calculate daily basis. my data as follows

A1 = 1-Apr-14 B1 100
A2 = 3-Apr-14 B2 200
A3 = 3-Apr-14 B3 300

I need to formula to populate sum of 1-Apr-14 value in one cell, sum of 3-Apr-14 value in another cell.

Please help
Related:

4 replies

Answer 1 / 4
Posts
1944
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 26, 2021
 145
swathisuda, Good morning.

Try to use:

D1 --> =SUMIF(A1:A3,"1-Apr-2014",B1:B3)

Is this what you want?
I hope it helps
--
Belo Horizonte, Brasil.
Marcílio Lobão
Answer 2 / 4
Posts
3
Registration date
Thursday April 3, 2014
Status
Member
Last seen
April 5, 2014
Hi Mazzaropi,

Thanks for the code I tried but it is not working. check below link for the excel i'm working.

http://www.wikiupload.com/D4YVTFUHA2TD4IQ

Thanks in advance.
Answer 3 / 4
Posts
1944
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 26, 2021
 145
swathisuda, Good morning.

Did you try to change comma by semi-colon at the formula?

Sorry, but your link is pointing me to a site where I need to register and etc to enter.
Please, may you save your Excel file to a FREE site, www.speedyshare.com and put your link here.

I'm sure that we will find an answer to your question.
Answer 4 / 4
Posts
3
Registration date
Thursday April 3, 2014
Status
Member
Last seen
April 5, 2014
Hi I tried but it is throwing error.

I uploaded file to website. please check

http://speedy.sh/uXPBp/2014.1.xls
Report
Posts
2819
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 25, 2021
 487
Hi Swathisuda,

The formula you used in column A referred to itself, which doesn't make sense.

Take a look at your file to see if it is working now:
http://speedy.sh/52KQ8/swathisuda-Formula.xls

Best regards,
Trowa
Ask a question