Summing cents only in currency column

[jbrown]

I have a column of currency amounts and I need to separate the sum of the dollar amount in one cell and the sum of the cents (everything after the decimal) in another cell. How do i write a formula to do this?
Thanks for any help you can give me!

 

[Yogi Anand]

Hi jbrown:

How about ...

yTempl011
	A	B	C	D	E
1
2		5.25	5	25
3		12.41	12	41
4		23.35	23	35
5
Sheet3

 

[Aladin Akyurek]

I have a column of currency amounts and I need to separate the sum of the dollar amount in one cell and the sum of the cents (everything after the decimal) in another cell. How do i write a formula to do this?
Thanks for any help you can give me!

B2:

=SUMPRODUCT(TRUNC(A2:A5))

C2:

=SUMPRODUCT(A2:A5-TRUNC(A2:A5))

but, since we have a result in B2, better to invoke:

=SUM(A2:A5)-B2

 

[jbrown]

This works great thanks!