| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Question involving two columns and returning a count | Excel Discussion (Misc queries) | |||
| Count Question | Excel Discussion (Misc queries) | |||
| Count If formula question | Excel Discussion (Misc queries) | |||
| Count If formula question | Excel Discussion (Misc queries) | |||
| Count If formula question | Excel Discussion (Misc queries) | |||
Hybrid Mode
