Stuck! How do group these ranges with totals?

		Microsoft Office Forums > Microsoft Excel > Excel
Stuck! How do group these ranges with totals?

FAQ

Thread Tools

Display Modes

06-13-2017, 07:52 PM

Logit

Windows 10 Stuck! How do group these ranges with totals?

Office 2007

Expert

Join Date: Jan 2017

Posts: 591

Code:

Col D Formula:			
=SUMIFS(A2:A13,A2:A13,">50",A2:A13,"<500")			
			
Col E Formula :			
=SUMPRODUCT(($A$2:$A$13>50)*($A$2:$A$13<500))			
			
H2 Formula:			
=SUM(A2:A13)			
			
I2 Formula			
=SUM(D2:D10)

The formulas change slightly for each denomination range and # of Accts.

You will need to change the upper range of the formulas to match how many
rows you are using in your workbook. ex: instead of A13 perhaps A500.
.
.

Attached Files

Cash Out Totals.xlsx (10.8 KB, 9 views)

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Take String of numbers, expand ranges, sort, then compress back into ranges	AustinBrister	Word VBA	19	08-22-2016 05:18 PM
Group records - multiple IF stmts - Text After Group	baum12	Mail Merge	1	05-25-2015 12:57 AM
Group Table Rows/Column (like Excel Group)	eoinymc	Word	1	03-11-2014 04:51 AM
Range Lookup for Totals? Confused	lawnG	Excel	1	02-01-2011 10:42 AM
Please help with Sum formula to add totals by State! asap	dutch4fire23	Excel	0	07-28-2006 12:41 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:12 AM.