Thread: =SUMIF Help!!
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] keemeng03@yahoo.com is offline
external usenet poster
 
Posts: 1
Default =SUMIF Help!!

Any one can help up the following case, how to set up the number in
"criteria" to be continue, so that i not neet to key in one by one, sample

=SUMIF('Data In (Agent 1)'!B14:B233,"003",'Data In (Agent 1)'!C14:C233)

as above sample format, how to automatically adjust the number "003" to
"004" for the next row format?

thank you.

regards,
Lee