View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default How can I link the "sumif" criteria to a cell? thks

=sumif(a:a,b1,c:c)
or
=sumif(a:a,""&b1,c:c)



Lauravila wrote:

--

Dave Peterson