count formula question

[mcook]

I am working in a spreadsheet with two worksheets in it. On worksheet 1 I
want to enter a formula that tells me how many cells in column h5:h622 on the
second sheet have a “1†in it, but I only want it to count it if column
f5:f622 (also on the second sheet) says “FEE- Monthlyâ€. Any tips?? Thanks!

 

[Domenic]

I am working in a spreadsheet with two worksheets in it. On worksheet 1 I
want to enter a formula that tells me how many cells in column h5:h622 on the
second sheet have a “1†in it, but I only want it to count it if column
f5:f622 (also on the second sheet) says “FEE- Monthlyâ€. Any tips?? Thanks!

Try...

=SUMPRODUCT(--('Sheet2'!$H$5:$H$622=1),--('Sheet2'!$F$5:$F$622= "FEE-
Monthly"))

 

[mcook]

I actually figured it out, thanks!
=SUMIF('OD Detail'!$F$5:$F$662,"FEE- MONTHLY",'OD Detail'!H5:H662)