Hi,
How can I use the countif function to count values in a table, only if the cell in the previous column has a "Y" value in it? I have attached some sample data. The top section has all the values and the bottom has a summary which should give a summary of the number of each level, only if they have a "Y" indicator. Is countif the right approach for this?
Thanks
hi ezzy85, try:
=IF(SUMPRODUCT(($A$3:$A$25="Y")*(B$3:B$25=$A30))=0,"",SUMPRODUCT(($A$3:$A$25="Y")*(B$3:B$25=$A30)))
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
by the looks of it, you have Excel 2007, which has the function of COUNTIFS.
put the following in cell B30, then drag it right and down:
Please Login or Register to view this content.
- i.s.z -
CSE, aka Array aka { }, formulae are confirmed with CONTROL+SHIFT+ENTER.
Replace commas ( , ) with semicolons ( ; ) in formulae, if your locale setting demands.
All good ideas are courtesy resources from this forum as well as others around the web.
- e.o.m -
thats perfect. thanks all!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks