• 466K Members
• 8,529 Online
• 563K Conversations

## COUNTIF HELP

Occasional Contributor

# COUNTIF HELP

Hi, i posted earlier re staff going to fires, i have since been told to use the COUNTIF formula. this works great if i just want to count the "F" in my range but i was wondering if there is a way to use this formula or anyother formula to add the "F" and the "FF" in the same rage to get an answer of 2 please see attached images to help show what i mean.

2 Replies

# Re: COUNTIF HELP

You can use wild cards if that helps.

=COUNTIFS(B2:E2,"F*")

But if wild cards won't work, for example, you need to count the F and T cells, you could use 2 formulas:

=COUNTIFS(B2:E2,"F")+COUNTIFS(B2:E2,"T")

# Re: COUNTIF HELP

Or

=SUM(COUNTIF(B2:E2,{"F","T"}))
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies