Count If table problems

**phoztek** · 06-20-2011, 06:32 AM

Hi all,

I could use some help on this,

I have the following count if formula

=COUNTIF(Bookings!$A$10:$A10;VQ!$E$4)

This "count if " is in a separated sheet and when i remove any line from the table from the Bookings Sheet, it will not update it and I will need to manualy update the count if ( table ).

The count if goes trough,

=COUNTIF(Bookings!$A$10:$A10;VQ!$E$4)
=COUNTIF(Bookings!$A$10:$A200;VQ!$E$4)

Thanks in advance,

**teylyn** · 06-20-2011, 06:51 AM

Hello,

try this formula instead

=COUNTIF(Bookings!$A$10:INDEX(Bookings!A:A;ROW(A10));VQ!$E$4)

This will not mind if you insert or delete rows in the Bookings sheet.

cheers,

**phoztek** · 06-20-2011, 10:40 AM

Originally Posted by teylyn

Hello,

try this formula instead

=COUNTIF(Bookings!$A$10:INDEX(Bookings!A:A;ROW(A10));VQ!$E$4)

This will not mind if you insert or delete rows in the Bookings sheet.

cheers,

Hi Teylin

Thank you so much, i've tested it and it seems to be working.

Cheers