Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

I have 2 columns, "machine type" and "install date". What I want to do is count the number of machines per type once they are installed. So if there were 3 "Machinetype1" installed 11/29/13, I want another cell to keep that total 3. I don't care what the install date is, as long as it is filled out. In another cell, I will keep the number of "Machinetype2" installed.

share|improve this question
    
Please let me know if this is not clear. –  Mike Maher Dec 3 '13 at 20:22
    
Best is to create an example file, with the expected outcome and share that with us. –  Jacob Jan Tuinstra Dec 4 '13 at 10:55

1 Answer 1

Assuming a layout as shown:

WA52670 example

please try:

=COUNTIFS(B:B,">"&0,A:A,A2)  

copied down to C4.

Where there are many machine types and/or the first entries in ColumnA do not serve as they do in the image, either create a list of machine types and use the location of the top of that list instead of A2 or simply copy the whole way down regardless and accept that the result for that machine type will be shown on every row for that machine type (eg C9:C11 as another 'set' and C12 as an individual).

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.