Please see attached
Sheet 1, 2, 3 = Raw data column A changes constantly,
Sheet4
D2 - I want a sum up that uses the week number on row A, as well as the current formula. So when i change the week number on row A it will look for that week only
Please see attached
Sheet 1, 2, 3 = Raw data column A changes constantly,
Sheet4
D2 - I want a sum up that uses the week number on row A, as well as the current formula. So when i change the week number on row A it will look for that week only
In D2 copied across and down:
=SUMPRODUCT((Sheet1!$A$5:$A$152=Sheet4!$A2)*(Sheet1!$B$5:$B$152=Sheet4!$B2)*(Sheet1!$C$5:$C$152=Sheet4!$C2)*(Sheet1!$D$1:$N$1=Sheet4!D$1),Sheet1!$D$5:$N$152)
By the way, you man row 1: rows are horizontal with number labels, columns are vertical with letter labels.
Last edited by AliGW; 06-22-2020 at 05:05 AM.
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.
That works great, Cheers Ali
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks