Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
4 SETS OF CRITERIA USED TO DISPLAY ANSWER | Excel Discussion (Misc queries) | |||
Sumif as a fuction of If using multiple criteria | Excel Worksheet Functions | |||
Vlookup for 2 sets of Criteria (or do I need to use something else | Excel Discussion (Misc queries) | |||
vlookup with 2 sets of criteria | Excel Discussion (Misc queries) | |||
SUMIF with two sets of criteria | Excel Discussion (Misc queries) |