Formula calculate daily income in excel

Closed
swathisuda
Posts
3
Registration date
Thursday April 3, 2014
Status
Member
Last seen
April 5, 2014
- Apr 3, 2014 at 10:23 AM
TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
- Apr 15, 2014 at 11:23 AM
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

Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
147
Apr 4, 2014 at 10:57 AM
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
0
swathisuda
Posts
3
Registration date
Thursday April 3, 2014
Status
Member
Last seen
April 5, 2014

Apr 4, 2014 at 11:19 PM
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.
0
Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
147
Apr 5, 2014 at 08:57 AM
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.
0
swathisuda
Posts
3
Registration date
Thursday April 3, 2014
Status
Member
Last seen
April 5, 2014

Apr 5, 2014 at 10:29 AM
Hi I tried but it is throwing error.

I uploaded file to website. please check

http://speedy.sh/uXPBp/2014.1.xls
0
TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
512
Apr 15, 2014 at 11:23 AM
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
0