sum if problem, trying to find best solution

Yes you can make different lists of variable length, then apply my formula
changing $F1:$F4 for whatever the new list is.

Cheers,
--
AP

"shalombi" <shalombi.28o33a_1149070800.5468@excelforum-nospam.com> a écrit
dans le message de news:
shalombi.28o33a_1149070800.5468@excelforum-nospam.com...
>
> Ok so in my case i have 4 different types in need to separate in, so if
> i make lists in separate collumns like you said F1:f4 for one thing and
> G1:G5 in another i can reference to them that way?
>
> Well ill try what you said, thank you for the prompt reply anyway.
>
> Max
>
>
> --
> shalombi
> ------------------------------------------------------------------------
> shalombi's Profile:
> http://www.excelforum.com/member.php...o&userid=34967
> View this thread: http://www.excelforum.com/showthread...hreadid=547037
>

Thanks alot ive been able to mae my 5 different types grid and now its all nice and clean, I owe you guys.

Max