Make CountIF work like SUMIF

[Myles Bauer]

How can I make COUNTIF work like SUMIF? What I am looking to do is on sumif
you have "range,criteria,sum_range" on countif you have "range,criteria" I
need a count range.

TIA,
Myles

BTW, Debra you helped me in the past with a sumproduct issue.

 

[Vasant Nanavati]

Perhaps:

=SUMPRODUCT((range=criteria)*(count_range<>""))

 

[Myles Bauer]

Vasant,
Help me a little more, I am an excel idiot when it comes to sumproduct.
More detail will be helpful what I'm trying to do is I have 2 managers doing
the same job in the same department. The current spreadsheet counts the
department as a whole I've added a column with the managers initials and I'm
trying to seperate the total numbers by manager. I appreciate any help you
can give.

Myles

 

[Vasant Nanavati]

Myles, what exactly are you trying to count (as opposed to sum)?

 

[Myles Bauer]

Can I send you a copy of the worksheet? That would explain it better.

Myles

 

[Myles Bauer]

Vasant,
I slept on it and figured it out myself Thanks for your suggestion it
worked!!!

Myles

 

[Vasant Nanavati]

Good. Sorry I wasn't able to get back to you before!