Need a little help with a formula
by Morten_Reitoft - 11/26/10 10:55 AM
Dear fellow Numbers Users..
I have a table with zip codes (Column A) and in the same table I have a list of house holds (Column B).
I would like to calculate a sum of house holds based on two fields describing Zip Codes FROM to Zip Codes TO.. I.e. I have a zip code 4000 to 4100. In this range there is maybe 6-7 zip codes with different number of house holds...
I can't figure out how to make that look up and sum.. I have tried to use Sum.if - but apparently I am not clever enough...!
Thank in advance,
Morten (From Denmark... reason for my bad English!)