In A1 of Sheet2 I have a state abbreviation such as NY
In B1 this formula will sum column C entries which have that state in column
A, and FT in column B
=SUMIFS(Sheet1!C:C,Sheet1!A:A,Sheet2!A1,Sheet1!B:B ,"FT")
Note that SUMIFS (with a final S) is new to Excel 2007
Prior to that you would have used
=SUMPRODUCT(--(Sheet1!A:A=Sheet1!A1),--(Sheet1!B:B="FT"),Sheet1!C:C)
except only Excel 2007 allows full column references in SUMPRODUCT
best wishes


"Joe S" wrote in message
...
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.?
--
joe s