Previous Topic Next Topic

Excel help

Closed
ririz99 - Jun 5, 2010 at 10:23 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 6, 2010 at 02:42 PM
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

Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 5, 2010 at 10:49 AM
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
0
ririz99
Jun 6, 2010 at 04:00 AM
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
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 6, 2010 at 06:24 AM
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
0
ririz99
Jun 6, 2010 at 10:02 AM
Hi rivisa1,

Is there anyway I can email the spreadsheet across to you? My email is mechrex@gmail.com.
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 6, 2010 at 02:42 PM
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
0

Similar discussions

Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses