Thread: HOW CAN I SET UP IF AMOUNT IN COL A = 0 THEN ADD B COL
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tom Hutchins Tom Hutchins is offline
external usenet poster
  
Posts: 1,069
Default HOW CAN I SET UP IF AMOUNT IN COL A = 0 THEN ADD B COL
Not sure if this is what you want, but how about

=SUMIF(A1:A3,0,B1:B3)

Hope this helps,

Hutch

"a babe in need" wrote:

Hi can anyone help me I am trying to work out a VAT return short cut
if my col A has a total of 0.00 in it I want to add its number next door in B
i.e. a1 2.50 b1 3.50 a2 0.00 b2 4.40 a3 3.00 b3 2.00
total I am looking for is 4.40 I hope this makes sense
Reply With QuoteReply With Quote