Excel help [Closed]

Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I have an excel spreadsheet which I used to keep track of some records. A sample as below:

ColumnA ColumnB
Row1 07/09/09 5
Row2 08/09/09 -2
Row3 13/09/09 10
Row4 02/10/09 12
Row5 31/01/10 -22
...
...
...
Row50

Column A is where I put a date in ddmmyy format.
Column B is an integer value

Appreciate if someone could write a formula that does the following:

1. Ability to scan row1 to row50 on columnA, return me the sum of the integers from columnb for that month. Note, some months there are more than 1 record and some months there are 0 records.

The results should look something like this:

Sep-09 13
Oct-09 12
Nov-09 No records
Dec-09 No records
Jan-10 -22

If there are months with 0 records then I want the text "No records' to appear.

Tks
ririz99

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
767
By return, are you saying that a sort of summary sheet should be created for all the months in the sheet. ? need more information about the date range and how you are looking to get the total
Hi rivisa1,

Thanks for responding. Using the above as example, for month of sep 09, I have 3 records. If you manually sum it up, it will give you a result of 13 (5 + (-2) + 10) = 13.

However, the number of records varies each month, sometimes more sometimes less and sometimes zero record.

It will be good to have a formula to automatically sum up the records based on month by month.

Rgds
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
767
I understand the sum part, What I don't understand is how that sum in being used/called. I can call it in various ways
1. on a given cell i will say for this month and for this month only give me a sum
2. i can have a list of month generated automatically and have their sum
3. i can have all the months written on a sheet and have the sum filed in for those months.
4. There can be multiple years in the data and i want for each year the monthly totals
and list goes on....

I hope you get what I was asking before as your answer still is silent on those lines. You have to go into far more detail about "how" part
Hi rivisa1,

Is there anyway I can email the spreadsheet across to you? My email is mechrex@gmail.com.
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
767
You upload a sample file with sample data etc on some shared site like https://authentification.site , http://wikisend.com/ , http://www.editgrid.com etc and post back here the link

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!