SUM Help? PLEASE

[HotNumbers]

I know this is a silly question but i need some help or some IDEAS? PLEASE

I have the issues where a user will fill in a table with data..
Column A is Invoice number
Column B is Invoice Total
Column C is should be THE total of Column C but if it doesn't total the same then next to it should be flagged with not total or something like it.

The total should be based on the INVOICE no...


I hope this make sense... Below is my example

Excel 2010
	B	C	D	E
1	Invoice No.	Invoice Total	Amount for Split Allocation	Amount Check
2	aaa	$ 100.00	$ 10.00
3	aaa		$ 10.00
4	aaa		$ 80.00
5	bb	$ 10.00	$ 1.00
6	bb		$ 9.00
7	ccc	$ 125.00	$ 5.00
8	ccc		$ 2.00
9	ccc		$ 6.00
10	ccc		$ 25.00
11	ccc		$ 32.00
12	ccc		$ 2.00
ZAP upload xlsx format

 

[NeonRedSharpie]

=IF($B3="",$D2+$C3,$C3)

That will work for a quick visual check...but that's as much as I've got.

=IF($B3<>"",SUMIFS($C:$C,$A:$A,$A3),"")

Duh...after posting I realized this. This should show you the value. If you want it to only show if it's different, add another if function!

=IF(IF($B13<>"",SUMIFS($C:$C,$A:$A,$A13),"")=$B13,"",IF($B13<>"",SUMIFS($C:$C,$A:$A,$A13),""))

 

[bbott]

Here's another similar option:

=IF(SUMIF($A$2:$A$1000,A2,$C$2:$C$1000)<>INDEX($A$2:$B$1000,MATCH(A2,$A$2:$A$1000,0),2),"Check this one","")