Formula to calculate value based on current cell and all data above

**Dena** · 09-12-2012, 06:42 PM

I have a spreadsheet that has this formula =SUMIFS(K:K,C:C,"X",B:B,$B2) but I only want it to calculate the data from its current row and above. Nothing entered below. Is that possible?

**oeldere** · 09-12-2012, 06:44 PM

I can't open the file (I get the pop up: invalid attachment)

**Dena** · 09-12-2012, 06:49 PM

12-13 budget- Test.xlsx

Here is the attachment

**oeldere** · 09-12-2012, 06:55 PM

Look if this is what you're up to.

**Dena** · 09-12-2012, 06:57 PM

Exactly what I needed, thank you. I love this forum. Nothing but genuine help. Thanks again.

**oeldere** · 09-12-2012, 07:00 PM

=SOMMEN.ALS($K$2:$K6;$C$2:$C6;"X";$B$2:$B6;$B6)

Add the red cell in you formula.

Glad I could help. Thanks for the reply.

If the question is solved, will you mark your question as solved?

If you have (other) questions, on this item, just ask.