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

4 replies

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
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.
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.
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
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