"If" Problem
 

I am trying to generate a spredsheet to help me with my VAT Returns. I am
entering data in rows. Colunm "A2" is simply the date. Column "B" is an "In"
or "Out" payment. Col "C" is a value in £. I would like to total all the "In"
values and return the answer into cell "F1" and total all the "Out" values
and return the answer into cell "F2". Can any one help?

A B C
date In £200
date In £567
date Out £55
date In £678
date Out £555

Cheers

Andy

"If" Problem
 

=SUMIF(B2:B10,"In",C2:C10)



--
Regards,

Peo Sjoblom


"ANDY" wrote in message
...
I am trying to generate a spredsheet to help me with my VAT Returns. I am
entering data in rows. Colunm "A2" is simply the date. Column "B" is an
"In"
or "Out" payment. Col "C" is a value in £. I would like to total all the
"In"
values and return the answer into cell "F1" and total all the "Out" values
and return the answer into cell "F2". Can any one help?

A B C
date In £200
date In £567
date Out £55
date In £678
date Out £555

Cheers

Andy

"If" Problem
 

Hi Andy

=SUMIF(B:B,"In",C:C)
and
=SUMIF(B:B,"Out",C:C)

--
Regards
Roger Govier



"ANDY" wrote in message
...
I am trying to generate a spredsheet to help me with my VAT Returns. I am
entering data in rows. Colunm "A2" is simply the date. Column "B" is an
"In"
or "Out" payment. Col "C" is a value in £. I would like to total all the
"In"
values and return the answer into cell "F1" and total all the "Out" values
and return the answer into cell "F2". Can any one help?

A B C
date In £200
date In £567
date Out £55
date In £678
date Out £555

Cheers

Andy