Hello All
please see attahed
In cell T7
This currently looks at 2 dates and sums up anything between 2 dates. However I don’t want the sum to include the columns in red as they are normally hidden and must be ignored
I would rather it use the week numbers. But either way it must ignore the hidden columns in red
Paul
I think you mean this (not advanced):
=VLOOKUP($B7,'MFG 7 Weeks'!$P$1:$Y$1082,4,0)-SUMIFS($G7:$Q7,$G$6:$Q$6,">="&$T$6,$G$6:$Q$6,"<="&$U$6,$G$6:$Q$6,"<>")
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
its still including the red columns. the sum needs to look at G7 & I7 & K7 & M7 & O7 & Q7 only.
i need it to ignore the red columns it should = 2682 when in looking at the above cells only
Try this:
=VLOOKUP($B7,'MFG 7 Weeks'!$P$1:$Y$1082,4,0)-SUMIFS($G7:$Q7,$G$6:$Q$6,">="&$T$6,$G$6:$Q$6,"<="&$U$6,$G$6:$Q$6,"<>0")
thanks Ali... excell gives me a bad Head
i just had to remove = so it was < (less than)
works great now
Good!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks