Formula calculate daily income in excel
Closed
swathisuda
TrowaD
- Posts
- 3
- Registration date
- Thursday April 3, 2014
- Status
- Member
- Last seen
- April 5, 2014
TrowaD
- Posts
- 2886
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 27, 2022
Related:
- How to calculate per day salary in excel
- How to calculate salary per day in excel - Best answers
- Per day salary calculation formula in excel - Best answers
- Excel formula to calculate 90 days from a specific date - Guide
- Automatic day counter in excel ✓ - Forum - Excel
- How to calculate monthly attendance percentage in excel - Forum - Excel
- How to change day month year to month day year in excel - Guide
- How to calculate formulas across worksheets in excel - Guide
4 replies
Mazzaropi
Apr 4, 2014 at 10:57 AM
- Posts
- 1963
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- April 25, 2022
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
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
Apr 4, 2014 at 11:19 PM
- 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.
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
Apr 5, 2014 at 08:57 AM
- Posts
- 1963
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- April 25, 2022
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.
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
Apr 5, 2014 at 10:29 AM
- 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
I uploaded file to website. please check
http://speedy.sh/uXPBp/2014.1.xls
TrowaD
Apr 15, 2014 at 11:23 AM
- Posts
- 2886
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 27, 2022
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
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