View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mark D[_2_] Mark D[_2_] is offline
external usenet poster
 
Posts: 52
Default IF FUCTION WITH 2 SETS OF CRITERIA

Good afternoon all, I am looking for some help if possible

I need excel to take a sum based on 2 sets of critiera

I put cells in just for reference

For example

Office Band Amount
A1: London B1: 4 C1: 2000
A2: Geneva B2: 3 C2: 3000
A3: Stuttgart B3: 2 C3: 4000

So I am trying to do the following

=IF(A1="London" AND, B1=4,c1)

I know the calculation above isnt right but I am trying like mad to work it
out and am stuck.

Any help greatly appreciated.