macro with sumif

O

orquidea

Hi:

I want to set a macro which will work with the sumif formula below. The
range (B1:B3 and A1:A3) will be relative every time and would vary the number
of rows subject to be considered. I think I will have to select the range
first with Selection.End(xlDown).Select. But I can not figure out how to
code it.

=SUMIF(B1:B3,20,A1:A3)

Thanks in advance for any help.

Orquidea
 

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

Macro with sumif 4
SUMIF with criteria "<>" & "=" 4
VBA Coding Help for Beginner 0
sum working hours each month (sum hours in the last row for a monthin a table with dates) 3
SUMIF data that falls within a range 3
Use TODAY() function as the criteria in a SUMIF formula 1
Need help calculating probabilities 7
Macro with sum function 1

Top