I am trying to write VBA code for this
=SUMIF(Q:Q,"S",N:N)
Column N is where I want the value results to be. I want it to populate via sumif results in the first blank "" cell in the range of Column N.
So really just to loop every cell in column N and then at first blank cell, insert the =SUMIF(Q:Q,"S",N:N)
Hi
Can you please upload a desenitised copy of your spreadsheet. It will make life easier to write and test.
Cheers
I cannot upload for some reason so here is a screenshot
Capture.PNG
A screenshot is useless!
Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.
I will move this thread to the VBA section.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Thanks for the tip ALIGW, very helpful.
I added the xlsm attachment
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks