Count code not working

**bouncey** · 10-10-2010, 08:33 PM

I need some help with the following

HTML Code:

I have my first tab named "tube data" with a count on the hidden sheet 2 with the above code in my final sheet. The only problem being is, it won't add the count and just leaves the code in the cell!

I have had this working.

Anybody have any ideas??

**peterjuhnke** · 10-10-2010, 08:43 PM

Hello bouncy
The = sign should be on the out side of the brackets
Attach a dummy sheet if this does not solve anything
Regards
Peter

**Marcol** · 10-10-2010, 08:52 PM

Have you tried putting this in the required cell, (without the curly brackets)

=SUM(IF('Tube Data'!$D$2:$D$1090=B5,Sheet2!$D$2:$D$1028,0))

Then confirm with
Ctrl+Shift+Enter

Hope this helps

**bouncey** · 10-10-2010, 08:52 PM

I believe that it is the correct way (conditional sum).

**bouncey** · 10-10-2010, 08:56 PM

Thanks Marcol. Thats the winner

**Marcol** · 10-10-2010, 08:59 PM

Happy to help.

Count code not working

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Count code not working

Re: Count code not working

Re: Count code not working

Re: Count code not working

Re: Count code not working

Re: Count code not working

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions