Afternoon,
I am using Excel 2010 and using the following formula to count the number of times a value is in a column:
=COUNTIF(EXPORTED!W:W,Q1)
However, now I need another formula that will only do the above forumla if A3 is in column Q.
Any ideas please?
Many thanks
Cmorgan,
Give this a try:
Please Login or Register to view this content.
Last edited by tigeravatar; 11-04-2011 at 12:37 PM.
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
If you want to count the number of rows where both criteria are met then try COUNTIFS (with an "S")
=COUNTIFS(EXPORTED!W:W,Q1,EXPORTED!Q:Q,A3)
Audere est facere
Thanys, worked a treat.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks