Count IF

[Jasmine]

I have a worksheet that lists name, customer and amount
sold. I am doing a sum product to get the total sold for
each name. Using this formula prevents me from having to
open the worksheet that the information is contained on.
I also need to count how many entries per name. I can do
this with the CountIF, but then Ihave to open the other
worksheet for the data to refresh. Is there another Count
function that I can use? Thanks!

 

[Dave R.]

You can use sumproduct in a similar way if it will help;

=SUMPRODUCT(--(A1:A100="UAL"))

 

[Peo Sjoblom]

You can use SUMPRODUCT to count as well

=COUNTIF(A2:A100,"a")

using sumproduct to get the same answer

=SUMPRODUCT(--(A2:A100="a"))

to make it easy open the other workbook and adapt accordingly and then excel
will
provide the path when you close it or use the path etc from the sum
sumproduct



--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)