Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help with CountIF function
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help with CountIF function
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" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help with CountIF function
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" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF function | Excel Discussion (Misc queries) | |||
please help how to combine IF function with Countif function | Excel Worksheet Functions | |||
How do I use a countif function according to two other countif fu. | Excel Worksheet Functions | |||
Embed a countif function in subtotal function? | Excel Worksheet Functions | |||
CountIf function | Excel Worksheet Functions |