Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello
I am relatively new to VB and need help. I am not quite sure how to accomplish this.... I need routine that will find the first blank cell in Col H and insert a sumproduct type formula. That will sum all of the cells in Col H where the value in the same row in col G is equal to "o" and the value in col F contains "F". I also need to replicate this over 20 columns in the same row. I am still trying to learn how to use sumproduct so if the formula use would be different, what would this be? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sumproduct with Condition OR Sumproduct with ADDRESS function - HE | Excel Discussion (Misc queries) | |||
Conditional SUMPRODUCT or SUMPRODUCT with Filters | Excel Worksheet Functions | |||
sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
Sumproduct | Excel Discussion (Misc queries) | |||
=SUMPRODUCT | Excel Discussion (Misc queries) |