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!