Count occurences from one worksheet to another with "IF" Criteria

J

jeannie v

Hi Experts: I've done this before but it's been quite a while and I'm having
trouble getting the results I want....This is what I want to do: On
Worksheet 1, If Column “A†= “ABCD†and Column “H†= “Dummyâ€, Count
Occurrences in Column “I†If Greater Than “0†and Enter in Cell “G4†on
Worksheet 2.

Could someone tell me how to do this?

Thank you for any help you can provide.
 
S

Steve Schapel

Jeannie,

The focus of this newsgroup is Macros in Access, the database program.
It appears your question is related to Excel, and you will have a better
chance of a good answer if you can repost to an Excel related group.
 

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

Count with two criteria in a second worksheet 1
Macro VBA coding, Copying content from one workbook to a new one 0
Countif, IF condition is met 2
Using countif with multiple criteria 0
count data from one sheet to another 4
Count occurences from one worksheet to another with "IF" Criteria 4
Count Distinct Values based on criteria 4
Excel 03 VLOOKUP hyperlink referencing and formatting 3

Top