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