Question:

How to use countif function in two different workbooks in ms excel 2003?

by  |  earlier

0 LIKES UnLike

Hi i have an excel sheet containing like this

column A coulmn B

345 J

456 J

----- ----

459 E

like this now i need to count how many J's and i need to get in another excel sheet

 Tags:

   Report
Answer The Question I've Same Question Too

1 ANSWERS

Sort By: Date  |  Rating

  1. Assuming J appears only in column B of Sheet1

    Enter the following in any cell of any worksheet where you want the value to appear (except, of course, the cells referenced in the statement - column B of Sheet1)

    =COUNTIF(Sheet1!B:B,"J")

    If you want to limit the range in column B that is checked to B2 through B50, change the statement to

    =COUNTIF(Sheet1!B2:B50,"J")

    If you want to be able to move the value around with copy (or cut) and paste, add $ signs as indicated below

    =COUNTIF(Sheet1!$B$2:$B$50,"J")

You're reading: How to use countif function in two different workbooks in ms excel 2003?

Question Stats

Latest activity: earlier.
This question has 1 answers.

BECOME A GUIDE

Share your knowledge and help people by answering questions.
Register Now