Microsoft Office Forums - View Single Post - Stuck! How do group these ranges with totals?

Logit · 06-13-2017, 07:52 PM

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.
.
.