formula calculate daily income in excelClosed

Question

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

Mazzaropi · Answer

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

swathisuda · Answer

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.

Mazzaropi · Answer

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.

swathisuda · Answer

Hi I tried but it is throwing error.

I uploaded file to website. please check

http://speedy.sh/uXPBp/2014.1.xls

Formula calculate daily income in excel

4 replies

Subscribe To Our Newsletter!