I'm having a problem with excel formaula... need help?
 

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

I'm having a problem with excel formaula... need help?
 

maybe this will work for you, just change the sheet name and ranges

=SUMPRODUCT((Sheet1!A1:A20=3)*(Sheet1!B1:B20=1))

--


Gary


"Bren" wrote in message
...
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