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 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Apr 15, 2014 at 11:23 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 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
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:
- How to calculate per day salary in excel
- How to calculate position in excel ✓ - Office Software Forum
- How to calculate position (1st,2nd,3rd) in excel....? - Excel Forum
- Calculation of positions in excel ✓ - Excel Forum
- It usually takes us just over a day to review your information - Facebook Forum
- Number to words in excel - Guide
4 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Apr 4, 2014 at 10:57 AM
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
