Need help with CountIF function
in [Functions]
|
Prev: fv of a periodical unequal investment
Next: Can I use a Reference inside a SUMIF or COUNTIF Function?
From: Flo on 14 May 2010 11:08 Hello, Please help. I have a columne A with department codes A, B, C, ... the department codes are multiple lines, column B with numbers when there are activity in that department. Can I do a countif function or other function to summerize how many activity each department?
From: Luke M on 14 May 2010 11:14 To count how many times there is activity for dept A: =SUMPRODUCT(--(A2:A100="A"),--(ISNUMBER(B2:B100)) To sum the numbers in column B associated with dept A: =SUMIF(A:A,"A",B:B) -- Best Regards, Luke M "Flo" <Flo(a)discussions.microsoft.com> wrote in message news:E7F90CF9-7E0D-4D84-9EB8-1046FE3EC910(a)microsoft.com... > Hello, > > Please help. I have a columne A with department codes A, B, C, ... the > department codes are multiple lines, column B with numbers when there are > activity in that department. Can I do a countif function or other > function > to summerize how many activity each department?
From: Ashish Mathur on 14 May 2010 20:36
Hi, Create a pivot table. Drag department code to the row area and numbers column to the data area -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Flo" <Flo(a)discussions.microsoft.com> wrote in message news:E7F90CF9-7E0D-4D84-9EB8-1046FE3EC910(a)microsoft.com... > Hello, > > Please help. I have a columne A with department codes A, B, C, ... the > department codes are multiple lines, column B with numbers when there are > activity in that department. Can I do a countif function or other > function > to summerize how many activity each department? |