I am trying to finalize a SUMIF formula that just appears to need some tweaking. Here is a sample of what I am attempting:
ExcelSnip.PNG
I am asking the formula to add numbers in column B when the values in column A are the same. The formula seems to be working "once" (e.g. C1 = B1 and B2) but then puts in another value (C2) that I do not want.
Is there a solution to this dilemma?
Thank you.
Hi
I think you could adjust references as in (A1 and B1 free)
=SUMIF(A1:A$100,A1,B1:B$100)
Hope it helps
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.
Please, mark your thread [SOLVED] if you received your answer.
John, welcome to the forum
1st, Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
Also, not all members can upload picture files (Company firewalls and stuff)
Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.
Having said that, if you want a cummulative total as you copy down, try something like....
=SUMIF(A$1:A1,A1,B$1:B1)
If you want the total shown for every match, change that to this...
=SUMIF(A$1:A$100,A1,B$1:B$100)
Last edited by FDibbins; 10-01-2014 at 11:40 AM.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hi mrsgloria and welcome to the forum.
Please not that forum rules require you to start your own thread, bit post on another member's thread
And, we have a forum for saying "Hi" and introducing yourself
Thank you but I am not seeing an option for uploading a file.
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"
Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.
Workbook Sample.xlsx
Attached.
Thanks
Based on your sample, try this, copied down...
=IF(COUNTIF($A$1:A1,A1)>1,"",SUMIF($A$1:$A$6,A1,$B$1:$B$6))
Thanks, FD. I could get your formula to work for a couple of cells then it started totaling zero. I am trying something else with subtotals and I will see if that works and
report here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks