count formula question

  • Thread starter Thread starter mcook
  • Start date Start date
M

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

Try...

=SUMPRODUCT(--('Sheet2'!$H$5:$H$622=1),--('Sheet2'!$F$5:$F$622= "FEE-
Monthly"))
 
I actually figured it out, thanks!
=SUMIF('OD Detail'!$F$5:$F$662,"FEE- MONTHLY",'OD Detail'!H5:H662)
 
Back
Top