|
|
#1
12-02-2013, 05:16 PM
|
|||
|
|||
[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))) Last edited by beginner; 12-04-2013 at 12:57 AM. Reason: solved 
|
|
#2
12-03-2013, 06:59 AM
|
||||
|
||||
Perhaps try this instead
Code:
=SUMPRODUCT((($A$2:INDEX($A$2:$A$10,MATCH(TRUE,INDEX($B$2:$B$10="",0),0)))=D2)*($B$2:INDEX($B$2:$B$10,MATCH(TRUE,INDEX($B$2:$B$10="",0),0))))
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|
|
| Thread Tools | |
| Display Modes | |
|
|
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 |
Windows 7 32bit 
Office 2007
Linear Mode
