Previous Topic Next Topic

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
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 responses

Answer 1 / 4
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 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

Similar discussions

Can the formula COUNTA / COUNT exclude 0 values?
doublewitt -
doublewitt -

2 responses
auto row copy to another worksheet
barryhall -
Anon -

8 responses
Duplicate rows based on cell value
fireburn -
TrowaD -

16 responses
Grey out an entire row in Excel 2010 depending on a cell's value
deeptis -
T -

11 responses
Change Date Format - dd/mm/yyyy HH:MM:SS to mm/dd/yyyy HH:MM:SS
asmfiaz -
Mazzaropi -

2 responses
How to stop today function date changing every day in Excel
Haneen H -
Klaas86 -

9 responses