Thread: "If" Problem
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Andy Andy is offline
external usenet poster
 
Posts: 414
Default "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