View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mikael L
 
Posts: n/a
Default Sum & two column conditions

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.