Using the COUNT function to count letters generated by an IF function
I'm trying to create a standings chart in Excel and I want to count the amount of wins, losses, and draws. I used an IF statement to determine if the game was a win, loss, or draw and output a "W", "L", or "D".
This is the statement I used.
"=IF(E7>0, "W", IF(E7<0, "L", "D"))"
Now, on the standings sheet, I'd like to count the W's in the W column, the L's in the L column, and the D's in the D column.
The problem I'm having is that when I run the function "=COUNT(DC!F2:F8, "W")", it gives a value of "0". It does this for L and D as well. How do I get the Count function to recognize the W, L, and D. I'd like the standings page to automatically update when I add new results to the team's sheets.
Also, is there a way to multiply the count of W's by 3?, L by 0, and D's by 1 and then sum the total in another cell?
Re: Using the COUNT function to count letters generated by an IF function
You need COUNTIF not COUNT - try this for a single function
for the total try
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By RyanF in forum Excel General
Last Post: 06-23-2009, 11:16 AM
By JK1234 in forum Excel Formulas & Functions
Last Post: 08-01-2008, 02:44 PM
By Zboy in forum Excel Programming / VBA / Macros
Last Post: 03-31-2008, 12:22 AM
By calli in forum Excel - New Users/Basics
Last Post: 01-28-2008, 05:34 PM
By Linda in forum Excel Formulas & Functions
Last Post: 11-10-2005, 12:55 PM
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1