I am putting together a spreadsheet of data that needs to be tallied; I
created a dataworksheet and a summary tab. I am having a problem creating one
of the formula's needed, which is:

from reference cell on tally summary, I am writing the formula. I need the
formula to go to data worksheet tab, reference column "A" and if "3", then go
to column "B" and count if "1".
Any chances someone can help me with a resolution... I've tried IF, COUNT,
COUNTIF, DCOUNT... I'm having problems with the two column criteria, etc.
Thanks ~ Bren