Countif

[Alaska1]

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.

[p45cal]

In B3 you could try:

=SUM(COUNTIF('April Raw Data'!A2:A8,{"Savings Accounts","Guardian Account"}))

and in C3:

=SUM(COUNTIFS('April Raw Data'!A2:A8,{"Savings Accounts","Guardian Account"},'April Raw Data'!B2:B8,"<>"))

[Alaska1]

Thank you! It worked. I appreciate your quick response.