VBA - sum a column based on date









up vote
-3
down vote

favorite












I'm looking to use a VBA to sum a specified column in my workbook based on the date listed in column A. So, for example if the date in column A is 05/09/2018, it will provide a sum total of the values recorded in column L on that date and put that sum total figure in a cell in column M. I've attached a screenshot of my table columns below, any help would be appreciated as I am still learning VBA. Thank you!



enter image description here






excel vba







share|improve this question



















  • 2




    Why do you want to do it using vba? You can use SUMIF function to do that.
    – Pavel_V
    yesterday










  • Hi, i understand it would be fairly simple to do using a SUMIF however the team i am working on this workbook with have suggested having that process automated.
    – NHure92
    yesterday






  • 1




    The sumif equivalent exists in vba, but why complicate with vba - if someone turns off macros then it will stop working....
    – Solar Mike
    yesterday










  • I am not sure what kind of automation you think can be achieved via vba in this that cant be done using the SUMIF function. If you setup the function it will "automatically" calculate the result if you change the input cells. In VBA you can either create UDF to handle this which will do totally the same thing or you can create a macro that needs to be either manually run or run based on some event/trigger, which is kind of equally or less automatic than a function.
    – Pavel_V
    yesterday











  • Possible duplicate of Error when using SUMIFS from different worksheet
    – OwlsSleeping
    yesterday














up vote
-3
down vote

favorite












I'm looking to use a VBA to sum a specified column in my workbook based on the date listed in column A. So, for example if the date in column A is 05/09/2018, it will provide a sum total of the values recorded in column L on that date and put that sum total figure in a cell in column M. I've attached a screenshot of my table columns below, any help would be appreciated as I am still learning VBA. Thank you!



enter image description here






excel vba







share|improve this question



















  • 2




    Why do you want to do it using vba? You can use SUMIF function to do that.
    – Pavel_V
    yesterday










  • Hi, i understand it would be fairly simple to do using a SUMIF however the team i am working on this workbook with have suggested having that process automated.
    – NHure92
    yesterday






  • 1




    The sumif equivalent exists in vba, but why complicate with vba - if someone turns off macros then it will stop working....
    – Solar Mike
    yesterday










  • I am not sure what kind of automation you think can be achieved via vba in this that cant be done using the SUMIF function. If you setup the function it will "automatically" calculate the result if you change the input cells. In VBA you can either create UDF to handle this which will do totally the same thing or you can create a macro that needs to be either manually run or run based on some event/trigger, which is kind of equally or less automatic than a function.
    – Pavel_V
    yesterday











  • Possible duplicate of Error when using SUMIFS from different worksheet
    – OwlsSleeping
    yesterday












up vote
-3
down vote

favorite









up vote
-3
down vote

favorite











I'm looking to use a VBA to sum a specified column in my workbook based on the date listed in column A. So, for example if the date in column A is 05/09/2018, it will provide a sum total of the values recorded in column L on that date and put that sum total figure in a cell in column M. I've attached a screenshot of my table columns below, any help would be appreciated as I am still learning VBA. Thank you!



enter image description here






excel vba







share|improve this question















I'm looking to use a VBA to sum a specified column in my workbook based on the date listed in column A. So, for example if the date in column A is 05/09/2018, it will provide a sum total of the values recorded in column L on that date and put that sum total figure in a cell in column M. I've attached a screenshot of my table columns below, any help would be appreciated as I am still learning VBA. Thank you!



enter image description here






excel vba




excel vba






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited yesterday









Cindy Meister

12.9k101934




12.9k101934










asked yesterday









NHure92

376




376







  • 2




    Why do you want to do it using vba? You can use SUMIF function to do that.
    – Pavel_V
    yesterday










  • Hi, i understand it would be fairly simple to do using a SUMIF however the team i am working on this workbook with have suggested having that process automated.
    – NHure92
    yesterday






  • 1




    The sumif equivalent exists in vba, but why complicate with vba - if someone turns off macros then it will stop working....
    – Solar Mike
    yesterday










  • I am not sure what kind of automation you think can be achieved via vba in this that cant be done using the SUMIF function. If you setup the function it will "automatically" calculate the result if you change the input cells. In VBA you can either create UDF to handle this which will do totally the same thing or you can create a macro that needs to be either manually run or run based on some event/trigger, which is kind of equally or less automatic than a function.
    – Pavel_V
    yesterday











  • Possible duplicate of Error when using SUMIFS from different worksheet
    – OwlsSleeping
    yesterday












  • 2




    Why do you want to do it using vba? You can use SUMIF function to do that.
    – Pavel_V
    yesterday










  • Hi, i understand it would be fairly simple to do using a SUMIF however the team i am working on this workbook with have suggested having that process automated.
    – NHure92
    yesterday






  • 1




    The sumif equivalent exists in vba, but why complicate with vba - if someone turns off macros then it will stop working....
    – Solar Mike
    yesterday










  • I am not sure what kind of automation you think can be achieved via vba in this that cant be done using the SUMIF function. If you setup the function it will "automatically" calculate the result if you change the input cells. In VBA you can either create UDF to handle this which will do totally the same thing or you can create a macro that needs to be either manually run or run based on some event/trigger, which is kind of equally or less automatic than a function.
    – Pavel_V
    yesterday











  • Possible duplicate of Error when using SUMIFS from different worksheet
    – OwlsSleeping
    yesterday







2




2




Why do you want to do it using vba? You can use SUMIF function to do that.
– Pavel_V
yesterday




Why do you want to do it using vba? You can use SUMIF function to do that.
– Pavel_V
yesterday












Hi, i understand it would be fairly simple to do using a SUMIF however the team i am working on this workbook with have suggested having that process automated.
– NHure92
yesterday




Hi, i understand it would be fairly simple to do using a SUMIF however the team i am working on this workbook with have suggested having that process automated.
– NHure92
yesterday




1




1




The sumif equivalent exists in vba, but why complicate with vba - if someone turns off macros then it will stop working....
– Solar Mike
yesterday




The sumif equivalent exists in vba, but why complicate with vba - if someone turns off macros then it will stop working....
– Solar Mike
yesterday












I am not sure what kind of automation you think can be achieved via vba in this that cant be done using the SUMIF function. If you setup the function it will "automatically" calculate the result if you change the input cells. In VBA you can either create UDF to handle this which will do totally the same thing or you can create a macro that needs to be either manually run or run based on some event/trigger, which is kind of equally or less automatic than a function.
– Pavel_V
yesterday





I am not sure what kind of automation you think can be achieved via vba in this that cant be done using the SUMIF function. If you setup the function it will "automatically" calculate the result if you change the input cells. In VBA you can either create UDF to handle this which will do totally the same thing or you can create a macro that needs to be either manually run or run based on some event/trigger, which is kind of equally or less automatic than a function.
– Pavel_V
yesterday













Possible duplicate of Error when using SUMIFS from different worksheet
– OwlsSleeping
yesterday




Possible duplicate of Error when using SUMIFS from different worksheet
– OwlsSleeping
yesterday

















active

oldest

votes











Your Answer






StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);













 

draft saved


draft discarded


















StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53222158%2fvba-sum-a-column-based-on-date%23new-answer', 'question_page');

);

Post as a guest






















active

oldest

votes













active

oldest

votes









active

oldest

votes






active

oldest

votes















 

draft saved


draft discarded















































 


draft saved


draft discarded














StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53222158%2fvba-sum-a-column-based-on-date%23new-answer', 'question_page');

);

Post as a guest

































































-

這個網誌中的熱門文章

How to combine Bézier curves to a surface?

圖片
Clash Royale CLAN TAG #URR8PPP up vote 2 down vote favorite My aim is to smooth the terrain in a video game. Therefore I contrived an algorithm that makes use of Bézier curves of different orders. But this algorithm is defined in a two dimensional space for now. To shift it into the third dimension I need to somehow combine the Bézier curves. Given two curves in each two dimensions, how can I combine them to build a surface? I thought about something like a curve of a curve. Or maybe I could multiply them somehow. How can I combine them to cause the wanted behavior? Is there a common approach? In the image you can see the input, on the left, and the output, on the right, of the algorithm that works in a two dimensional space. For the real application there is a three dimensional input. The algorithm relays only on the adjacent tiles. Given these it will define the control points of the mentioned Bézier curve. Additionally it marks one side of the curve as inside t
閱讀完整內容

Carbon dioxide

圖片
"CO2" redirects here. For other uses, see CO2 (disambiguation). Carbon dioxide Names Other names Carbonic acid gas Carbonic anhydride Carbonic oxide Carbon oxide Carbon(IV) oxide Dry ice (solid phase) Identifiers CAS Number 124-38-9   Y 3D model (JSmol) Interactive image Interactive image 3DMet B01131 Beilstein Reference 1900390 ChEBI CHEBI:16526   Y ChEMBL ChEMBL1231871   N ChemSpider 274   Y ECHA InfoCard 100.004.271 EC Number 204-696-9 E number E290 (preservatives) Gmelin Reference 989 KEGG D00004   Y MeSH Carbon+dioxide PubChem CID 280 RTECS number FF6400000 UNII 142M471B3J   Y UN number 1013 (gas), 1845 (solid) InChI InChI=1S/CO2/c2-1-3   Y Key: CURLTUGMZLYLDI-UHFFFAOYSA-N   Y InChI=1/CO2/c2-1-3 Key: CURLTUGMZLYLDI-UHFFFAOYAO SMILES O=C=O C(=O)=O Properties Chemical formula C O 2 Molar mass 44.01 g·mol −1 Appearance Colorless gas Odor Low concentrations: none High concentrations: sharp; acidic [1] Density 1562 kg/m 3 (solid at 1 atm and −78.5 °C) 1101 kg/m 3 (liquid at
閱讀完整內容

Why am i infinitely getting the same tweet with the Twitter Search API?

圖片
up vote 0 down vote favorite My code workes perfectly for other queries, but for one query I am infinitely getting the same tweet. I can't understand what the problem is. API call: query='Allergic asthma OR Nonallergic asthma OR Occupational asthma OR EIB OR Exercise-induced bronchoconstriction OR Nocturnal asthma OR Cough-variant asthma' new_tweets = api.search(q=searchQuery, count=100, since_id=since_id, lang='en',tweet_mode='extended') if not new_tweets: print("No more tweets found") break for tweet in new_tweets: if True: print(jsonpickle.encode(tweet._json, unpicklable=False)) my_file = open('searchTweets.txt','a') my_file.write(jsonpickle.encode(tweet._json, unpicklable=False)+'n') my_file.close() else: continue Output in file: https://pastebin.com/JmRCsTeE These are the JSONs of the same Tweet. Other queries that work: Breast cancer OR Prostate cancer OR Colon cancer OR Lung cancer Type 2 dia
閱讀完整內容