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?
|