Add qualifier to andif statement

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
litngldy said:
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
Click to expand...


CRUD.....I know I know....it's SUMIF not ANDIF....sorry
 
Bernard,
I'm confused...I'm summing data in F that meets criteria A3 to B3, now I
want to
only sum if H equals "name"

A3= Jan1
B3=Jan31
F$3:F$218 are entry dates
G$3:G$218 are hours worked
H$3:H$218 are employee name

I want to sum any Jan1-Jan31 hours for "Bob"

I hope that's clearer

Thanks alot for the help

Steve
 
This SUMS
=SUMPRODUCT(--($F$3:$F$100>=$A$3),--($F$3:$F$100<=$B$3),--($H$3:$H$100="name"),
$f$3:$f$100)
This counts
=SUMPRODUCT(--($F$3:$F$100>=$A$3),--($F$3:$F$100<=$B$3),--($H$3:$H$100="name"))
 
Back
Top