M
Manosh
Hi all,
I'd like to sum a column that contains a mix of numbers and text based on a condition that appears in a cell that is 2 rows 'down' from the number.
The structure looks something like this:
Week 1 Week 2...
500
Home
Name1 1
1000
Home
Name2 2
500
Home
Name1 1
In this case if i want to sum just for
Name1 i should get 1000 (500+500) for Week 1, and
Name2 i should get 1000 (1000) for Week 1.
I need to do this over several weeks and i may have more that 2 names.
Is there a way that you can recommend i achieve this?
Unfortunately i cannot change the structure!
Many thanks in advance!
Manosh
I'd like to sum a column that contains a mix of numbers and text based on a condition that appears in a cell that is 2 rows 'down' from the number.
The structure looks something like this:
Week 1 Week 2...
500
Home
Name1 1
1000
Home
Name2 2
500
Home
Name1 1
In this case if i want to sum just for
Name1 i should get 1000 (500+500) for Week 1, and
Name2 i should get 1000 (1000) for Week 1.
I need to do this over several weeks and i may have more that 2 names.
Is there a way that you can recommend i achieve this?
Unfortunately i cannot change the structure!
Many thanks in advance!
Manosh