How to convert SumProduct function in VBA code ?

W

Wellie

I'm using the the following "sumproduct" excel function in the spreadsheet.

=SUMPRODUCT(--(A1:A2762=Acct_ID),--(F1:F2762=Metric_Name),--(G1:G2762))

It basically check data in colu,m A & F. If they meeting criteria stored in
cell "Acct_ID" and "Metirc_Name", it sums data in column G.

Can someone please tell me how can I convert the "sumproduct" function as
shown above to VBA code in subroutine similar to the the following 'subtotal'
function ?
With Application
SumVal = .Subtotal(9, Rng.Columns("H"))
end With
 
B

Bob Phillips

Simplest way

Sumval =
Evaluate("SUMPRODUCT(--(A1:A2762=Acct_ID),--(F1:F2762=Metric_Name),--(G1:G27
62))")

--

HTH

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMPRODUCT with filter 6
SUMPRODUCT and SUMIFS combined with Sumifbycolor (VBA code) 1
Sumproduct() - Need for speed or change 1
Problem sorting a range of columns using VBA 1
Move data from first 7 rows from one column A into multiple Columnsthen the next 7 rows 2
simple code but it doesn't look like usual vba code 2
Wildcard not working in SumProduct Array 8
Help creating a custom function in VBA 2

Top