Formula for getting total count of cells using multiple criteria and tabs

Hi everyone,

I'm working on this spreadsheet and have hit a roadblock. I need to add up the amount of cells have completed dates AND are 1 of 4 options: Bill, Prov, Maint, Other. This means I need "Prov completed", "Maint completed, bill completed, other completed" totals and they need to populate the totals for each on another tab.


There are 6 different tabs. Each tab represents a person, and each person has Bill, Prov, Maint, Other areas (they select which option from dropdown bars in column E). Each area has a "completed date" in another column J. I can't figure out how to populate for each person..the totals for their Billi, Prov, Maint, and Other that have completed dates entered in column J ONLY. (The totals go on another tab for over all total summaries)

I'm hitting a wall on how to make each "Completed" cell in my counter ONLY count the Bill. cells that have a completed date for each person. There seems to be 2 criteria here (to be bill, prov, maint, OR other AND has to have a completion date entered)

Can anyone offer guidance, please?

Thanks!!

Hi

Sumproduct, count(if may be used.
Please upload a sample file

Regards