Thread: [Solved] Countif
View Single Post
 
Old 05-23-2024, 01:32 PM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2021
Expert
  
Join Date: Apr 2014
Posts: 956
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
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,"<>"))
Reply With Quote