SUMIF formula that counts

[viber52]

I am trying to structure a formula that will count and sum specific values. More details in the spreadsheet attached.

[daffodil11]

I'd combine COUNTIF, SUMIF, and maybe some SUMPRODUCT.

I used some code to kill all the subtotals first. Data and it's summaries should be separate.

Please Login or Register  to view this content.

[viber52]

How do I use the same code you did?

[daffodil11]

Go to VB Editor with Alt+F11, Insert->Module, paste the code there, close that window, Alt+F8, and run it.

I just slapped that code together to make short work of clearing all of the spaces in between your data.

[viber52]

Thank you. The VBA and formulas work great. Rep Added!

[daffodil11]

Thank you. Glad I could help out.