count cells across muliple columns

[Guest]

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.

 

[Bernie Deitrick]

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

 

[Guest]

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

 

[Bernie Deitrick]

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