Hi guys,
I have two sheets. One is the master sheet with all the data. And the other is a sheet that i am pulling the totals from each specific value from.
On the master sheet i have a cell that acts like a week number.
I have many rows each one stating a week number and then i have enter a specific value on another column.
The total row calculates all values entered on that column but it changes according to the week number.
All i want to do is pull that data to another sheet. but instead of calculating all values for that specific week i want to calculate the total of each different value for that week.
I have attached a screenshot of my master sheet to see if it makes more sense.
On the green cell if i change to 13 it will count all values that were added on week 13.
I want to the same on the other sheet. As soon as i change the week number it pulls only the info for that week. But then again i want only the values for that specific week only
This is what i have tried but without success
B1 on my sheet is where i type the week number
=IF($B$1='Values'!$G$2,COUNTIF('Values'!J4:J,"SV9))
Because otherwise it will count all values with SV9 on that column and i have over a 1000 rows. and i dont to count all of those rows
Im sorry if i cant explain any better but hope this makes sense
I have two sheets. One is the master sheet with all the data. And the other is a sheet that i am pulling the totals from each specific value from.
On the master sheet i have a cell that acts like a week number.
I have many rows each one stating a week number and then i have enter a specific value on another column.
The total row calculates all values entered on that column but it changes according to the week number.
All i want to do is pull that data to another sheet. but instead of calculating all values for that specific week i want to calculate the total of each different value for that week.
I have attached a screenshot of my master sheet to see if it makes more sense.
On the green cell if i change to 13 it will count all values that were added on week 13.
I want to the same on the other sheet. As soon as i change the week number it pulls only the info for that week. But then again i want only the values for that specific week only
This is what i have tried but without success
B1 on my sheet is where i type the week number
=IF($B$1='Values'!$G$2,COUNTIF('Values'!J4:J,"SV9))
Because otherwise it will count all values with SV9 on that column and i have over a 1000 rows. and i dont to count all of those rows
Im sorry if i cant explain any better but hope this makes sense