Hi
can't get this to work
=SUMIF($E$7:$E$66,"=Lists!E3",$D$7:$D$66)
The range (E7 to E66) is data that is selected from drop down lists.
The criteria =Lists E3 is the first item in the list for the drop down lists which happens to be on another worksheet called Lists.
It works if i change the SUMIF to the actual string value for example:
=SUMIF($E$7:$E$66,"=Apple",$D$7:$D$66) where Apple is the first item in the list that generates the drop-down list.
I would prefer the formula to be dynamic as the data in the drop down list is dynamic.
Thanks
Bookmarks