I've setup a workbook that contains a lot calculations. One of the columns in my workbook is setup to check certain cells and based on conditions I've setup, the cells will be filled in with the word "red" or "green."
I need to learn how to create a function that will add up the number of cells that have the word "red" in them and divide that by the total number of cells ("red" or "green").
So essentially I'm finding an average: red cells over both red and green cells.
Is this possible?
Assuming you have more than just red & green possibilities
=COUNTIF(A:A,"red")/SUM(COUNTIF(A:A,{"red","green"}))
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Your post does not comply with Rule 5 of our Forum RULES. We have Seven question forums: Miscellaneous, General, Programming, Worksheet Functions, Charting, Excel 2007 Help and New Users. Please choose the appropriate forum, and post your question in ONLY one forum.
Please red the forum rules prior to posting another question... I have on this occasion moved the thread to an appropriate forum.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks