Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Hidden Cells Reference Problem

  Asked By: Joao    Date: Nov 20    Category: MS Office    Views: 762
  

I have a spreadsheet for controlling my staffs holidays.

I use the countif function to check if a "H" has been inputed on a
certain date and then times it by the cell above which contains the
hours i need for that particular day.

I have use some vba code(see message post 6533)to give me more
conditional formatting and character input as caps as well as using a
toggle switch to hide the hours value rows.

Everything works fine whilst these rows aren't hidden but if i hide
them the values aren't deducted unless i hide/unhide or just change
sheets.

Any ideas why this is?

Share: 

 

2 Answers Found

 
Answer #1    Answered By: Angelina Gardner     Answered On: Nov 20

You probably need to describe what you have in a bit more detail. I've just
tried what I think you're trying to do, and it works  fine.

I have 8 in H10 and I10
I have H in H11 and N in I11
I have "=COUNTIF(H11,"=H")*H10" in H12 and "=COUNTIF(I11,"=H")*I10" in I12
I have "=H12+I12" in K12
I have "=SUM(H12:I12)" in M12

I change H11 between H and N and back. H12, K12 and M12 all show what I'd
expect.

hide  row 10. The values  are still computed correctly as I change H11.

What do you have that's different?

 
Answer #2    Answered By: Dalpat Student     Answered On: Nov 20

Your code clued me in to what i'd done wrong.

I had my countif  functions on the same row i was hiding,doh.

Easy done i suppose

 
Didn't find what you were looking for? Find more on Hidden Cells Reference Problem Or get search suggestion and latest updates.




Tagged: