Counting using criteria from two columns

**wheelman55** · 11-08-2012, 07:01 PM

Hello...I'm new here...thanks in advance for the help

I'm stumped with a counting formula...

From a column with a hard number...I've successfully counted with this formula: =SUMPRODUCT(($C$21:$C$226="jared")*(D$21:D$226<>""))

What I want to do is to count from a column with a sum instead of a hard number.

Can I somehow replace the <>"" with a something that will count a summed value greater than zero? Or is there a different formula that I should be using?

Thanks...

**TMS** · 11-08-2012, 07:40 PM

Why not change <>"" to >0 then?

And why not use COUNTIFS?

Regards, TMS

**wheelman55** · 11-08-2012, 08:00 PM

TMS...that did the trick...not sure how to do this same thing with countif...would you elucidate?

**TMS** · 11-08-2012, 09:54 PM

You're welcome.

=COUNTIFS($C$21:$C$226,"jared",D$21:D$226,">0")

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save