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

B

Bren

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
 
G

Gary Keramidas

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

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

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

Using <= in countifs statement 1
Strip out certain rows that have merged cells 2
How to paste the same cell one tab over 1
Need Help with a VBA subroutine 0
Weighted % Complete calculation 1
Called procedure ignoring "With Sheets" command 2
Problems with count, counta and countifs 6
Macro that adds all numbers that have formulas 10

Top