Sum scattered data with same label

		Microsoft Office Forums > Microsoft Excel > Excel
Sum scattered data with same label

FAQ

Thread Tools

Display Modes

12-28-2016, 02:07 PM

jeffreybrown jeffreybrown is offline

Windows Vista Sum scattered data with same label

Office 2007

Expert

Join Date: Apr 2016

Posts: 673

jeffreybrown has a spectacular aura about

You're very welcome and thanks for the feedback.

Look at the offset ranges.

The criteria range starts in column A with the sum range beginning in column B.

=SUMIF(range,criteria,sum_range)

As long as the blank columns (C and F) remained spaced out in the same manner, you can use this sumif for more columns keeping the same pattern.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formatting data in scattered rows into rows following each other	MorneDJ	Excel	3	12-10-2016 12:35 AM
Pie chart showing more than one data label	chickasaw	Excel	2	03-10-2015 07:27 PM
How to add data label individually in a stacked-bar chart?	officeboy09	Excel	0	10-17-2013 01:26 AM
Display a label character in a data cell	markg2	Excel	9	09-07-2013 05:56 AM
Trying to merge label data from file	ClayShannon	Mail Merge	0	09-16-2009 10:08 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:20 AM.