Conditional Sumproduct

C

cbernal999

Joined
May 8, 2009
Messages
1
Reaction score
0
I am working on a report that needs to look at sheet 1 column A2 though A600. I need a count of unique numbers in this column. This formula is working = SUMPRODUCT((Sheet1!A2:Sheet1!A700<>"")/COUNTIF(Sheet1!A2:Sheet1!A700,Sheet1!A2:Sheet1!A700&"")) but I can only get a total. I also need to break down this count by state. IE: If on the worksheet "report" column a has AZ, IL, TX.

So if the state = AZ then count the unique numbers in sheet 1 a2 thorugh a600.

I keep getting Value and Name errors.

Thanks
Cbernal
 

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

Sorting and COUNTIF 6
COUNTIF, Sorting, on Two Sheets 1
SUMPRODUCT IF query 1
Excel VBA 1
SUMPRODUCT 2
counting how many of the same numbers 1
numbers instead if text 2
Conditional sum in a named range 8

Top