I have read so much on how to do this but I don't understand. I have this =SUMIF('Sale Items'!I:I,A6,'Sale Items'!G:G). I need it to exclude the hidden cells on the 'Sale Items' sheet. It seems like it should be really simple! I know it's probably not but please help me!
Hi
Assuming your data range is A2:B15
On the Sales Item sheet add an extra row and use =SUBTOTAL(102,B2). That formula will return a 1 if visible and a 0 if hidden. Then in your main SUMIF formula add the 1 criteria.
That should work for you
Chris
Click my star if I helped Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks