Hey guys,
I'm familiar with the SUMIF function, but am having difficulty creating a specific function which only sums up to the current cell... i.e. a cumulative SUMIF column.
I have attached a spreadsheet with a simplified version of my data but essentially the idea is this:
I would like to SUM all the sales of a certain product up to that particular sale... if I were to just use the normal SUMIF my cumulative cell would constantly update as later sales were added.
Any help?
Many thanks,
Todd
SUMIF Cumulative Calculation.xlsx
Last edited by makkystyle; 01-19-2012 at 04:43 PM.
I am not sure I understood You in proper way but try attachment (Array formula)
Regards
tom1977
If You are satisfied with my solution click the small star icon on the left to say thanks.
Try this to use SUMIF this way:
=SUMIF(C$3:C3,C3,D$3:D3)
copy down. Block the first cell in range & sum_range
HTH; Haseeb
If your problem is solved, please say so clearly, and mark your thread as Solved:
Forum Rules & How to Mark a thread as SOLVED
Thank you for the quick responses guys... I don't think I explained my problem clearly enough so I have updated my example file. Essentially the idea is that I would like to know what my total sales of an individual product are up to a each date or sale... i.e. a cumulative total. The problem is that after a certain threshold of sales my cost goes down for that product and I want to reflect that in some other calculations so this cumulative total can tell me when in the year I hit that threshold.
Should be clearly demonstrated in the attached spreadsheet. Basically I am hoping that there is a variant of the SUMIF formula so that this cumulative total column can identify which product was sold and then what the total sales for that product were up to this particular date.
New example attached for clarity.
Thank you!!!
SUMIF Cumulative Calculation_2.xlsx
If some more clarity would help here is the last file with an additional example of how I thought this might work, but unfortunately it doesn't seem to stick.
SUMIF Cumulative Calculation_3.xlsx
Hi
Maybe, just maybe, this;in F5:
=SUMIF($C$3:C5;C5;$D$3:D5)
Copy down.
Hope to helps you
Regards
Fotis.
I am proud that i am Greek.
Just to know every one.We Greeks, we are nοt proud of our politicians. Υou?
Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
My Avadar picture, is from Athens Acropolis.
http://www.theacropolismuseum.gr
http://www.visitgreece.gr/
Example...
Regards
Fotis.
I am proud that i am Greek.
Just to know every one.We Greeks, we are nοt proud of our politicians. Υou?
Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
My Avadar picture, is from Athens Acropolis.
http://www.theacropolismuseum.gr
http://www.visitgreece.gr/
Thanks for your replies guys. Fotis' solution worked. I needed to adjust the rows slightly but otherwise a good solution. A note that I found is you cannot use column references in your formula because for this particular formula you need to be more strict about which rows are included or not.
if you used my last formula correctly will work, =SUMIF(C$3:C3,C3,D$3:D3)
See the attached. Since you are on table format, will adjust automatically, if you add new/delete data
HTH; Haseeb
If your problem is solved, please say so clearly, and mark your thread as Solved:
Forum Rules & How to Mark a thread as SOLVED
Glad that you found your solution!
Regards
Fotis.
I am proud that i am Greek.
Just to know every one.We Greeks, we are nοt proud of our politicians. Υou?
Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
My Avadar picture, is from Athens Acropolis.
http://www.theacropolismuseum.gr
http://www.visitgreece.gr/
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks