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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 03:00 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com