I have been battling with the workbook attached but cannot find a solution. Everything has been explained therein. This is a call to our expert formula gurus to devise something which works.
Sum from a two-way table based on multiple criteria
-
-
-
Re: Sum from a two-way table based on multiple criteria
Essentially what we have above is the sum of a dynamic range. Picking up the new range each time as the city changes is where I am somewhat flummoxed!
-
Re: Sum from a two-way table based on multiple criteria
I played around with the formula below in H9:H13. It seems to work. What I did was to name the range under each city by the city name. For example, F6:F10 is named "Sydney", etc. for the other cities. Then, this formula in H9:H13 seemed to work (formula for H9 shown and filled down).
=SUMIF(INDIRECT($I$4),"="&I9,$B$6:$B$10)
Typing a new city in I4 changed the data (blanks show up as zeroes).
Not sure how this would work on your actual data, but maybe some modification can get close.
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!