Row Total Incorrect Using SumX

JNM

New Member
Joined
Jan 24, 2012
Messages
35
I have a simple table and am using sumx, but the row total is incorrect.

The measure is: =sumx(daily,[Gallons]*[NACVal]/[Acres])/[rows]

The output looks like this:
12345101112Grand TotalShould be:
4.8075.566 2.6913.2663.4616.33
2.691 2.692.69
3.6345.3824.4163.8412.6913.2664.4523.23
4.8075.5663.634 4.7414.00
4.8075.5663.634 3.8412.6913.2664.2723.80

<colgroup><col span="2"><col><col span="5"><col><col></colgroup><tbody>
</tbody>




<colgroup><col><col span="2"><col><col span="5"><col></colgroup><tbody>
</tbody>


<colgroup><col><col span="2"><col><col span="5"><col></colgroup><tbody>
</tbody>
 

Some videos you may like

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

nikio8

Board Regular
Joined
Oct 20, 2017
Messages
128
would you be able to provide screenshot with headers? Perhaps try using brackets, all of your data is in the same row/table, no duplicate rows?
 

JNM

New Member
Joined
Jan 24, 2012
Messages
35
ABCDEFG
1DateFieldGridMonthValNACValGalAcres
21/10/2019Ourada, Ken-E1510.0020946002
31/12/2019Ourada, Ken-E1610.0020946002
41/15/2019Ourada, Ken-E3510.0020946002
51/17/2019Ourada, Ken-E2510.0020946002
61/18/2019Ourada, Ken-E2710.0020946002
71/18/2019Ourada, Ken-E3710.0020946002
81/20/2019Ourada, Ken-E2610.0020946002
91/22/2019Ourada, Ken-E3810.0020946002
101/23/2019Ourada, Ken-A1610.0020946002
111/23/2019Ourada, Ken-I1610.0020946002
121/24/2019Ourada, Ken-A110.0020946002
131/24/2019Ourada, Ken-E3910.0020946002
141/26/2019Ourada, Ken-E2410.0020946002
151/27/2019Ourada, Ken-I1710.0020946002
161/27/2019Ourada, Ken-I2010.0020946002
171/29/2019Ourada, Ken-I2110.0020946002
181/30/2019Ourada, Ken-E3610.0020946002
191/31/2019Ourada, Ken-I1110.0020946002
201/31/2019Ourada, Ken-I2210.0020946002
212/1/2019Ourada, Ken-E1720.0024246002
222/1/2019Ourada, Ken-I1520.0024246002
232/2/2019Ourada, Ken-I2520.0024246002
242/2/2019Ourada, Ken-I2620.0024246002
252/3/2019Ourada, Ken-E1420.0024246002
262/6/2019Ourada, Ken-I1020.0024246002
272/6/2019Ourada, Ken-I1220.0024246002
282/7/2019Ourada, Ken-E1620.0024246002
292/8/2019Ourada, Ken-E3720.0024246002

<tbody>
</tbody>
Sheet1
There are no duplicates - there are multiple entries per day, but they would differ on field/grid combos. The NACVal changes monthly
 
Last edited:

nikio8

Board Regular
Joined
Oct 20, 2017
Messages
128
ok. looking at your data it is unclear what you are calculating. you are trying to save some ram or space not having an extra column, using sumx rather than sum. why do you divide by row?
i would first create simple formulas, make sure it works and then go on from there. perhaps rows is not connected to this table and you only get total row.
 

JNM

New Member
Joined
Jan 24, 2012
Messages
35
I ended up creating a measure for each month, then a measure that added all the months together.
 

Watch MrExcel Video

Forum statistics

Threads
1,096,418
Messages
5,450,289
Members
405,604
Latest member
Ahmed Mushtahid

This Week's Hot Topics

Top