Thread: change SUMIF formula into a vb code
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Umlas Bob Umlas is offline
external usenet poster
  
Posts: 301
Default change SUMIF formula into a vb code
ans=Evaluate("SUMIF($A$11:A18,A18,$D$11:D18)-SUMIF($A$11:A18,A18,$F$11:F18)"
)

"ASU" wrote in message
...
Is it possible to change the formula below into a VB code?

=SUMIF($A$11:A18,A18,$D$11:D18)-SUMIF($A$11:A18,A18,$F$11:F18)
--
ASU


Reply With QuoteReply With Quote