"litngldy" wrote:

I have a spreadsheet formua that I'd like to add a test to, for name in
another column.
The formula is =SUMIF($F$3:$F$218,"="&A3,$G$3:$G$218)
-SUMIF($F$3:$F$218,""&B2,$G$3:$G$218)

In this case I want to test a name in column H and only count G if name is
equal

So far I know a bunch of ways....that won't work..LOL....can someone help me
out

thanks.
Steve


CRUD.....I know I know....it's SUMIF not ANDIF....sorry