View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Doo0592 Doo0592 is offline
external usenet poster
 
Posts: 42
Default If and then statement to sum corresponding prices.

Hi all,

I am trying to set up a worksheet that will calculate up how much
money I'm spending on people for thier christmas and birthdays this
year (unfortunately they all come at once!). The english version of
the formula I'm am trying to write is

IF B3:B32 = "David" AND D3:D32= "Birthday" THEN K4 = sum of
corresponding price in F3:F32.

I have to admit I'm not very good with If and then statements but I
understand the basics of programming.