Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi Anyone
I have the following on a spreadshhet Col A Col B Col C Duncan cat1 10 Duncan cat2 30 Paul cat 3 5 Craig cat 1 60 Paul cat 2 30 Craig cat3 20 Duncan cat1 23 I would like to know the formula to add column C using column A as my first criteria then column B as my second criteria to achieve the following result Duncan Cat 1 = 33 Duncan Cat 2 = 30 Paul Cat 2 = 30 And so on All help is greatly appreciated |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculate percentage based on cells with conditional formatting | New Users to Excel | |||
counting cells (COUNTIF) based on two or more criteria | Excel Worksheet Functions | |||
How can I calculate Vacation Time earned based on length of emplo. | Excel Discussion (Misc queries) | |||
How do I calculate sum based on 3 conditions? | Excel Worksheet Functions | |||
Formula to determine a future date based on criteria | Excel Worksheet Functions |