I am using Excel 2021. In the attached workbook, I want to count in column A (Product) Savings Account and Guardian account in one total under Savings Account on the Total Worksheet column B. I tried combining using a countif statement between the two, but I could not get it to work.

Then in column C (Risk) on the total worksheet, I need it to count for Savings account and guardian account the total count of cells that has data in it.

Attached Files

test data.xlsx (9.5 KB, 6 views)