Countif

Alaska1 · #1 05-23-2024, 10:43 AM

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 · #2 05-23-2024, 01:32 PM

In B3 you could try:

Code:

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

and in C3:

Code:

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

Alaska1 · #3 05-23-2024, 02:24 PM

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
CountIF	Loopylee2020	Excel	2	08-23-2022 11:15 PM
If / countif	Kiwi971	Excel	1	06-03-2021 04:30 AM
COUNTIF - A vs. AA???	SoMany	Excel	4	01-01-2021 12:50 AM
Help with COUNTIF	MaineLady	Excel	1	05-24-2019 02:53 PM
Countif	hockeytown	Excel	3	01-05-2013 08:06 AM