J
Joe S
I have an Excel07 table with several columns, some with text, some with
numbers. I need to find a function to help me show a sum total (on another
worksheet in the same workbook)from a column of data from a couple of
different conditions.
For example the first column of data shows a list of states, a few columns
over the data shows "FT" or "PT". The next column shows the number of shifts
that are covered.
I want to show the total number FT shifts for a particular state in one cell
of my worksheet and the total number of PT shifts for that same state in the
adjacent cell.
I have tried this with sumifs and countifs but keep getting error messages.
Can someone please help.?
numbers. I need to find a function to help me show a sum total (on another
worksheet in the same workbook)from a column of data from a couple of
different conditions.
For example the first column of data shows a list of states, a few columns
over the data shows "FT" or "PT". The next column shows the number of shifts
that are covered.
I want to show the total number FT shifts for a particular state in one cell
of my worksheet and the total number of PT shifts for that same state in the
adjacent cell.
I have tried this with sumifs and countifs but keep getting error messages.
Can someone please help.?