Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I count a value if another field = a specific value? Excel
I'm trying to count a specific value only if another column has a specific
value. If column B=blue AND column I=App then count it. I'm sure it's simple but I can't seem to find a function to make it work... and I can't get the nested functions to work either... April |
#2
|
|||
|
|||
Try this, April:
http://www.officearticles.com/excel/...ft_excel.h tm ************ Anne Troy www.OfficeArticles.com "AprilCarter" wrote in message ... I'm trying to count a specific value only if another column has a specific value. If column B=blue AND column I=App then count it. I'm sure it's simple but I can't seem to find a function to make it work... and I can't get the nested functions to work either... April |
#3
|
|||
|
|||
THAT WORKS PERFECTLY!!! THANK YOU SO MUCH!
"Anne Troy" wrote: Try this, April: http://www.officearticles.com/excel/...ft_excel.h tm ************ Anne Troy www.OfficeArticles.com "AprilCarter" wrote in message ... I'm trying to count a specific value only if another column has a specific value. If column B=blue AND column I=App then count it. I'm sure it's simple but I can't seem to find a function to make it work... and I can't get the nested functions to work either... April |
#4
|
|||
|
|||
You're welcome!
************ Anne Troy www.OfficeArticles.com "AprilCarter" wrote in message ... THAT WORKS PERFECTLY!!! THANK YOU SO MUCH! "Anne Troy" wrote: Try this, April: http://www.officearticles.com/excel/...ft_excel.h tm ************ Anne Troy www.OfficeArticles.com "AprilCarter" wrote in message ... I'm trying to count a specific value only if another column has a specific value. If column B=blue AND column I=App then count it. I'm sure it's simple but I can't seem to find a function to make it work... and I can't get the nested functions to work either... April |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
Getting Count field to recognise rows with negative values in Exc. | Excel Worksheet Functions | |||
Can I count cells with specific format (e.g., yellow field?) | Excel Worksheet Functions | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions |