Two conditions in a SUMIF

[n8v_nerd]

Well, I've tried a few different ways, but can't find a way to make
SUMIF take two conditions...maybe there's a better way to do it.

I'm trying to make it go down, row by row and sum if two conditions ar
met...basic breakdown is:
IF item in B>0 AND item in F="FUBAR" SUM column T

Now, the other part of this is...can you do this with a COUNTIF also

 

[Don Guillett]

try
=sumproduct((b2:b200>0)*(f2:f200="fubur)*t2:t200)