Re: Row Count With Matching Cell Criteria

I'm sorry about the column D that I mentioned. I have my dates in
column M. I tried what you suggested, but the way I have it setup, it's
not working. The SUMPRODUCT(('Tank Chart'!A9:A1611="-J")*('Tank
Chart'!M9:M1611<>"")) worked if I took out the tank number and used the
word "test1" instead of "J" (putting test in place of the tank#). The
problem is it's not picking out the "J" from the tank number. When I
use COUNTIF(A9:A1611,"*-J*") to count the total number of J tanks, it
works, but it's not working for the sumproduct formula.

.

Relevant Pages

  • Re: Pepper Cory Lying Upside Down
    ... > I'd really rather not be picking a dead fish out of the tank ... Prev by Date: ...
    (rec.aquaria.freshwater.misc)
  • Re: Row Count With Matching Cell Criteria
    ... I tried what you suggested, but the way I have it setup, it's ... Chart'!M9:M1611"")) worked if I took out the tank number and used the word "test1" instead of "J". ... The problem is it's not picking out the "J" from the tank number. ... but it's not working for the sumproduct formula. ...
    (microsoft.public.excel)
  • Re: How do you get rid of Caulerpa prolifera??
    ... If you have tangs eating it, then by simply picking it yourself, it will make it easier for the tangs to finish it off. ... Another thing that you can do, is to keep an eye out for calerpa snails that eat the stuff. ... If the species of caulerpa you have is prolifera,then I have not found any snails that eat that much at all, and fish are less likely to eat it over other speices of caulerpa. ... but the good news is that it is the easiest to remove from the tank with your hands. ...
    (rec.aquaria.marine.reefs)
  • Re: Murder in the Malawi Tank
    ... All the labs were larger than the demasonis. ... I'm not sure what to do about this agressive fish. ... no one is picking on anyone. ... My two seem to have drawn up an imaginary line across the tank which only gets crossed for feeding time or chasing of one of the others. ...
    (rec.aquaria.freshwater.cichlids)
  • Re: What does everyone have in their tanks????
    ... 20-gallon Plant rootings tank. ... Aquarium plants: ... Moss (Taxiphyllum barbieri, prev. ... Vesicularia dubyana), Stringy Moss ...
    (rec.aquaria.freshwater.misc)