Solution for SUMIF

[aaaaaaiden]

What is the best solution for this scenario?

I have a large workbook with many worksheets. Each worksheet is a City, I have a macro that picks up expenses and puts them into the city worksheet but I need to summarise all of the expenses.

I have a list of end of month dates in Column B, I need to summarise these dates underneath and use a SUMIF in column I.

EXAMPLE OF WHAT I NEED:

COL B COL I
31/08/2013 200
30/06/2013 1200
31/08/2013 750
31/07/2013 650
30/06/2013 1000
30/06/2013 4500
30/06/2013 1500
31/07/2013 500
------------------------------------
31/08/2013 950
30/06/2013 8200
31/07/2013 1150

I think a macro would be best for this but I am unsure on how to do it. My current one doesn't work if there are less that 4 dates in column B. Could someone think of a better way to do this? At this moment in time I have:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[Bernie Deitrick]

I have a list of end of month dates in Column B..

On each sheet, or on one sheet?

I need to summarise these dates underneath and use a SUMIF in column I.

Of the same sheet?

EXAMPLE OF WHAT I NEED:

How about an example of what you have, first.

[AlKey]

Please see attached file and see if this helps with your task with formula.

[aaaaaaiden]

On each sheet, or on one sheet?

On each sheet

Of the same sheet?

Yes, on the same sheet

How about an example of what you have, first.

I shall have a look at AlKey's spreadsheet and if not then I shall reply to you with an example

[aaaaaaiden]

Please see attached file and see if this helps with your task with formula.

You have the right idea, except I need it underneath the dates and figures and the length of information is variable so it will have to be added automatically.. please see my example below.

[aaaaaaiden]

On each sheet, or on one sheet?



Of the same sheet?



How about an example of what you have, first.

test.xlsm

Run the Run macro
Then Run the Line 1 macro for the sumif problem

London is the problematic spreadsheet because the year end has a possible 4 lines and with my coding it uses coordinates that doesn't guarantee the correct outcome.

Please see the attachment which works for all but London because of my coding

[aaaaaaiden]

solved using RC formula instead

Please Login or Register  to view this content.