Sum up cells

		Microsoft Office Forums > Microsoft Excel > Excel
Sum up cells

12-02-2013, 05:16 PM

beginner

Windows 7 32bit Sum up cells

Office 2007

Advanced Beginner

Join Date: Sep 2011

Location: Europe

Posts: 45

[SOLVED] Sum up cells

I need to sum up the values above to the first blank cell using a formula with a particular condition. My formula is not working

Code:

=SUMIF($A$2:INDEX($A$2:$A$10;MATCH(TRUE;INDEX($A$2:$A$10=$D$2;0);0));D2;$B2:INDEX($B$2:$B$10;MATCH(TRUE;INDEX($B$2:$B$10="";0);0)))

Can somebody help me with formula (not VBA)

Attached Files

example.xls (17.5 KB, 13 views)

Last edited by beginner; 12-04-2013 at 12:57 AM. Reason: solved

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
In Excel 2007-After Selecting Visibe Cells-How do I "Copy to Visible cells" Only	mag	Excel	0	10-28-2012 08:04 PM
Un even cells	lostsoul62	Excel	5	10-17-2012 08:33 AM
How-TO format cells (FILL) by comparing cells	zanat0s	Excel	1	07-03-2012 04:27 AM
Count range cells eliminating merge cells	danbenedek	Excel	0	06-15-2010 12:40 AM
Display the cells which add up to a certain sum	edbyford	Excel	1	11-26-2009 01:30 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:37 PM.