counting the number of two different variables

N

Nick

I have a speadsheet with several tabs that I need to count two variables on
different pages. Simply, there is one (1) summary page and one (1) page I
want to point the formula at. The page I need to count has 2 columns, one
contains years (2004, 2005...etc) and another column contains 2 phrases
(early term and reg term). I need to count how many times "2004 and reg term"
occur, then "2004 and early term"...and so on. Any advice?
 
T

T. Valko

Try this:

=SUMPRODUCT(--(Sheet2!A1:A100=2004),--(Sheet2!B1:B100="reg term"))

Better to use cells to hold the criteria:

D1 = 2004
E1 = reg term

=SUMPRODUCT(--(Sheet2!A1:A100=D1),--(Sheet2!B1:B100=E1))

Adjust ranges/sheet name to suit.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting and deleting 7
How can I customise my headers so they are all different? 1
Counting the number of different entries in a column 2
Combining & counting data 2
counting blank cells within two columns 2
Counting by Two Columns of Variables 9
countif multiple 2003 3
Counting pages for tab 4

Top