Sum Then Count entries

[MarkKil]

Please assist with the following to create a Macro to run on all worksheets:

In the image below you can see that the data comes in at different times and the amount of times it is received also varies between 1 Hour to the next.

I need to sum on the Hour all values between, then count the number of entries that make up this sum

Sum and Count .jpg

also see the sample worksheet attached

Thank you all - I know everyone does appreciate your time an efforts in helping the less knowledgeable grow.

Mark

[leelnich]

...I need to sum on the Hour all values between, then count the number of entries...

1) Do you mean you need hourly updates, or merely a breakdown showing entries by hour?
2) Do you want to include entries occurring exactly on the hour with earlier entries OR with later entries?

[MarkKil]

1) Do you mean you need hourly updates, or merely a breakdown showing entries by hour?
2) Do you want to include entries occurring exactly on the hour with earlier entries OR with later entries?

Hope this assists
1) a breakdown showing entries by hour . As the data is only imported into the different sheets weekly
2) include entries occurring exactly on the hour with later entries

thanks for the reply

[Sintek]

Hi Mark

Here's one way...
I removed your comment on the sheet...

data will continue over 7days

Please Login or Register  to view this content.

[jindon]

MarkKil

Try

Please Login or Register  to view this content.

[leelnich]

Hope this assists... include entries occurring exactly on the hour with later entries.

Your partitions should begin at midnight (0 - 1, 1-2, ...23 - 24/0) to allow 24 subtotals.

[Sintek]

My apologies...Only after consideration of results I found errors in code for post 4...
Herewith amended...

Please Login or Register  to view this content.

[MarkKil]

THANK YOU ALL,- now i am able to achieve "Sum Then Count entries"

[Sintek]

Glad I could contribute...Thanks for rep +

[MarkKil]

Once again thanks --- i ve moved to own thread

[Sintek]

pls open a different thread. this has been solved and new requirement has nothing to do with current.