Sumif function?
 

I have a long detailed list of fixed assets. When the tax return for this
company was filed, assets were lumped together using a logic I have yet to
figure out. For example, one of the lump totals on the tax return was
$144,681. I know that 2 or more amounts in column c of my spreadsheet of
fixed assets will add up to this amount. Can I somehow use the sumif
function to figure out which the amounts in this column add up to $144,681?

Thanks for your time.

Claudia

Hi, Claudia. The only thing I've ever seen that addresses this issue:
http://www.mrexcel.com/pc09.shtml
*******************
~Anne Troy

www.OfficeArticles.com


"claudlarue" wrote in message
...
I have a long detailed list of fixed assets. When the tax return for this
company was filed, assets were lumped together using a logic I have yet to
figure out. For example, one of the lump totals on the tax return was
$144,681. I know that 2 or more amounts in column c of my spreadsheet of
fixed assets will add up to this amount. Can I somehow use the sumif
function to figure out which the amounts in this column add up to
$144,681?

Thanks for your time.

Claudia

Anne,

Wow. I guess it's not as simple as using a sumif formula. Thanks for the
response. It looks like I have my work cut out for me to see if I can even
begin to figure out if I can utilize that macro.

Claudia

"Anne Troy" wrote:

Hi, Claudia. The only thing I've ever seen that addresses this issue:
http://www.mrexcel.com/pc09.shtml
*******************
~Anne Troy

www.OfficeArticles.com


"claudlarue" wrote in message
...
I have a long detailed list of fixed assets. When the tax return for this
company was filed, assets were lumped together using a logic I have yet to
figure out. For example, one of the lump totals on the tax return was
$144,681. I know that 2 or more amounts in column c of my spreadsheet of
fixed assets will add up to this amount. Can I somehow use the sumif
function to figure out which the amounts in this column add up to
$144,681?

Thanks for your time.

Claudia