Sum up cells

		Microsoft Office Forums > Microsoft Excel > Excel
Sum up cells

FAQ

Thread Tools

Display Modes

12-03-2013, 06:59 AM

Pecoflyer

Windows 7 64bit Sum up cells

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,943

Pecoflyer has a reputation beyond repute

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

« Previous Thread | Next Thread »

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 12:42 PM.