First thank you for looking at this and helping and soory for the long post.
I'm not sure if I can relay what I'm doing without the spreadsheet but what
I have is this. I have about 700 rows of data with many columns, two columns
of information I want to use are vendor name (column G) and file name (column
A). What I am trying to do is use the file name as one filter and then count
how many vendors are listed with that same file name (vendors can be listed
multiple times but I only what to count each one once, there can also be a
blank cell for no vendor listed). I have tried this formula,
=SUMPRODUCT(--($A$4:$A$658='Summary
Data'!E1),(1/COUNTIF($G$4:$G$658,$G$4:$G$658&""))) and it works fine but when
I use the same formula like this, =SUMPRODUCT(--($A$4:$A$658='Summary
Data'!G1),(1/COUNTIF($G$4:$G$658,$G$4:$G$658&""))) I get 13.177 but it should
be 27.
Is there way a formula like this can work?

TIA
Joe