Carry out a cross-cast check in excel

[liamdocherty]

2.1Carry out a cross-cast check(on the funding worksheet – Total Funding) that uses secondary columns to perform the same calculation but in a different way to ensure your spreadsheet shows it is accurate.

How can I perform a cross check in my total funding that uses secondary columns to perform the same calculation but in a different way to ensure your spreadsheet shows it is accurate?

https://imgur.com/a/8iTc3Ju

Thanks,
Liam.

 

[BrianGGG]

There aren't too many "secondary columns". The only thing I can think of would be to compare the total of Column H with a SUMPRODUCT of the individual columns.
Something like:

SUM(H5:H24) = SUMPRODUCT((E5:E24*F5:F24)+G5:G24)

And, you could expand the range a bit if you weren't sure how many lines there were:

SUM(H5:H30) = SUMPRODUCT((E5:E30*F5:F30)+G5:G30)

 

[liamdocherty]

Hi,

thanks for the response. Where do I place this code formula?

 

[BrianGGG]

You could put it anywhere, really. The formulas are not dependent on the location.
I only have a picture rather than the actual data, so here is a complete example (only a few rows) with the checksum at the top.
You would know if something was wrong if the two totals at the top don't match at any given time:

	E	F	G	H	I
2		$15,300	Sum of Totals
3		$15,300	Checksum
4
5	Course Cost	Attendees	Basic	Extra	Total
6	$1,000	5	$5,000	$100	$5,100
7	$1,000	10	$10,000	$0	$10,000
8	$100	2	$200	$0	$200

<colgroup><col style="width: 25pxpx"><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula F2 =SUM(I6:I17) F3 =SUMPRODUCT( (E6:E17*F6:F17) + H6:H17 ) G6 =E6*F6 G7 =E7*F7 G8 =E8*F8 I6 =G6+H6 I7 =G7+H7 I8 =G8+H8 <thead> </thead><tbody> </tbody>

<tbody>
</tbody>