• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Vlookup CountIF

rbobcat1

rbobcat1

Member
All,

how would you write a formula to count the quantity of how many times a particular date on a different Tab.


i have this but can't seem to get it to work


=VLOOKUP(FirstTab!$A1,(=COUNTIF(SecondTab!$K:$K,"4/27/2012")))


Too few Arguments
 
Hi, rbobcat1!


VLOOKUP function is used for retrieving a value from a range searching for an argument on first column of the range and specifying from which column to get the data.


If you want to count how many times a particular date (or number, or string,...) you should use COUNTIF or COUNTIFS function. For the simplest case try this:

=COUNTIF(SecondTab!$K:$K,"4/27/2012")


Regards!
 
That is the way i was doing it but was trying to make a column with the dates involved and just tell it to look for that date in column a of first tab in table of secondtab and count how many time it finds it.
 
Hi, rbobcat1!

I'm afraid I don't understand the issue. Would you upload a sample file? Please refer to second green sticky post at this forums main page for guidelines. Thank you.

Regards!
 
You must log in or register to reply here.
Back
Top