count cells across muliple columns
 

I have a sheet with 5 columns. The columns have headers: Student Name,
Student Number, Grant Provider, Graduation Date, Status, and Employed By.

I need a formula that will count of the number of students on the sheet
based on criteria in this order - provider, then status, then if there is
text in the employed By column.
I think I can use a countif if but everything I have tried has not worked.
Thanks in advance.

Robb,

Use a pivot table. Select your data table (all five columns) and then use
Data | Pivot Table.. and click OK until you get a new sheet. Then drag
the provider button to the row field, the Status button to the row field,
and the Employed by Button to both the row field and the data field. You
will then get a table of counts summarized by the three columns, without
using a single formula. If your data table changes, make sure that you
either reselect the table using the pivot table wizard, or insert new rows
within the table for your new data.

HTH,
Bernie
MS Excel MVP


"Robb27" wrote in message
...
I have a sheet with 5 columns. The columns have headers: Student Name,
Student Number, Grant Provider, Graduation Date, Status, and Employed By.

I need a formula that will count of the number of students on the sheet
based on criteria in this order - provider, then status, then if there is
text in the employed By column.
I think I can use a countif if but everything I have tried has not worked.
Thanks in advance.

Thanks Bernie. You are on fire! - Can you recomend any good books on how to
fully understand and utilize pivot tables?

"Bernie Deitrick" wrote:

Robb,

Use a pivot table. Select your data table (all five columns) and then use
Data | Pivot Table.. and click OK until you get a new sheet. Then drag
the provider button to the row field, the Status button to the row field,
and the Employed by Button to both the row field and the data field. You
will then get a table of counts summarized by the three columns, without
using a single formula. If your data table changes, make sure that you
either reselect the table using the pivot table wizard, or insert new rows
within the table for your new data.

HTH,
Bernie
MS Excel MVP


"Robb27" wrote in message
...
I have a sheet with 5 columns. The columns have headers: Student Name,
Student Number, Grant Provider, Graduation Date, Status, and Employed By.

I need a formula that will count of the number of students on the sheet
based on criteria in this order - provider, then status, then if there is
text in the employed By column.
I think I can use a countif if but everything I have tried has not worked.
Thanks in advance.

Robb,

I have never found a good book on pivot tables. There are some web-based
resources, but the best way is to just play around. Drag things, click
things, right-click things, .....

HTH,
Bernie
MS Excel MVP


"Robb27" wrote in message
...
Thanks Bernie. You are on fire! - Can you recomend any good books on how
to
fully understand and utilize pivot tables?

"Bernie Deitrick" wrote:

Robb,

Use a pivot table. Select your data table (all five columns) and then
use
Data | Pivot Table.. and click OK until you get a new sheet. Then
drag
the provider button to the row field, the Status button to the row
field,
and the Employed by Button to both the row field and the data field.
You
will then get a table of counts summarized by the three columns, without
using a single formula. If your data table changes, make sure that you
either reselect the table using the pivot table wizard, or insert new
rows
within the table for your new data.

HTH,
Bernie
MS Excel MVP


"Robb27" wrote in message
...
I have a sheet with 5 columns. The columns have headers: Student Name,
Student Number, Grant Provider, Graduation Date, Status, and Employed
By.

I need a formula that will count of the number of students on the
sheet
based on criteria in this order - provider, then status, then if there
is
text in the employed By column.
I think I can use a countif if but everything I have tried has not
worked.
Thanks in advance.