Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-07-2022, 12:08 PM
realest25 realest25 is offline Hello friends. Please help ! COUNTIF formula ? Windows 7 64bit Hello friends. Please help ! COUNTIF formula ? Office 2019
Novice
Hello friends. Please help ! COUNTIF formula ?
 
Join Date: Jun 2022
Posts: 2
realest25 is on a distinguished road
Default Hello friends. Please help ! COUNTIF formula ?

Hello friends. Please help !



I want a formula ( maybe COUNTIF? ) to count how many "W" and "D" and "L" are found per each range: "B3:B12", "D312" and "F3:F12".

But to count only in the first 5 cells with value (that are NOT empty blank cells).

I don't want to count all "W" and "D" and "L" found in the entire range.

I want to count "W" and "D" and "L" on the first 5 filled cells, skiping the blank cells.

The formulas must be separate, meaning a formula to count just the value "W", another formula to count just the value "D", another formula to count just the value "L".

In short, to count in the first 5 cells that are not blank:
- how many "W"
- how many "D"
- how many "L"

I want to obtain the count from the green examples.

I DO NOT want to obtain the count from the red examples.

Please see bellow url image. Thank you !

ASK — ImgBB


This is cross-posted

Hello friends. Please help ! COUNTIF formula ? | MrExcel Message Board

Hello friends. Please help ! COUNTIF formula ?

Hello friends. Please help ! COUNTIF formula ?

COUNTIF formula ? | Chandoo.org Excel Forums - Become Awesome in Excel

https://www.msofficeforums.com/excel...f-formula.html

Hello friends. Please help ! COUNTIF formula ?

https://stackoverflow.com/questions/...35497_72536529

https://ccm.net/forum/affich-1158037...source=MagNews
Reply With Quote
Reply

Tags
countif, formula

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
If / countif Kiwi971 Excel 1 06-03-2021 04:30 AM
Help with COUNTIF MaineLady Excel 1 05-24-2019 02:53 PM
Using =countif formula with drop down box. wchristner Excel 0 02-19-2014 12:44 PM
Hello friends. Please help ! COUNTIF formula ? COUNTIF Formula teza2k06 Excel 3 02-13-2014 12:37 PM
IF formula returns TRUE instead of evaluating COUNTIF ColinC Excel 4 12-28-2011 08:21 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:52 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft