count formula question
 

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!

count formula question
 

In article ,
mcook wrote:

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"))

--
Domenic
http://www.xl-central.com

count formula question
 

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

"mcook" wrote:

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!