Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a sheet (Excel 2003) containing three columns where a condition in the
first column A should get a sum of values from column B and a count of values from column C. But I do not know how to do it. A B C TS 10 p TS 20 c TS 30 c TF 10 p TF 10 p D 30 c N 20 c What I want is to be able to sum col B if col A is e.g TS and col C is p (answer 10), then A=TS and C=c (answer 50). I then want to count the number of p if e.g. A=TS. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how can i multiply two columns | Excel Worksheet Functions | |||
Formula to Extract value on 3 column based on two conditions | Excel Discussion (Misc queries) | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
Add items in column 3 if column 1 and 2 conditions are met | Excel Worksheet Functions | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions |