Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 300
Default SUMIF in VBA on VBA variables?

I need the functionality of SUMIF in my VBA code. But not for a range.
These are Variant variables (two vectors of same length and a criteria).
For now I'll loop.

Don <donwiss at panix.com.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,272
Default SUMIF in VBA on VBA variables?

You could drop them into a worksheet range and then use SUMIF from within
VBA.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Don Wiss" wrote in message
...
I need the functionality of SUMIF in my VBA code. But not for a range.
These are Variant variables (two vectors of same length and a criteria).
For now I'll loop.

Don <donwiss at panix.com.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
sumif with 2 variables Dave Excel Discussion (Misc queries) 3 July 14th 08 09:39 AM
SUMIF with two or more variables B Benton Excel Worksheet Functions 1 October 13th 07 07:12 PM
Sumif with multiple variables les8 Excel Discussion (Misc queries) 5 April 8th 06 02:16 AM
SUMIF Formuale with 2 variables CiaraG Excel Worksheet Functions 3 February 15th 06 02:10 PM
SUMIF variables Steve Excel Discussion (Misc queries) 2 February 18th 05 01:32 PM


All times are GMT +1. The time now is 06:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"