Formula calculate daily income in excel [Closed]

Report
Posts
3
Registration date
Thursday April 3, 2014
Status
Member
Last seen
April 5, 2014
-
Posts
2669
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 15, 2020
-
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
1836
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 6, 2020
136
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
1836
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 6, 2020
136
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
2669
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 15, 2020
446
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