Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nesting SUMIF
I want to sum number in Column V if two conditions are met.
Condition 1: Data in Column K = SFD Condition 2: Data in Column AT = value in cell H2 on another Sheet. Dim Quarter As String Quarter = filtercontrolSheet.Range("H2") contents of cell is 2009/4 I've tried the formula but get error message "Invalid number of arguments" Thanks for the assistance. StatsForm.TextBox9 = Application.SumIf(planDataSheet.Range("K2:K" & Endrow), "SFD" And planDataSheet.Range("AT2:AT" & Endrow), Quarter, planDataSheet.Range("V2:V" & Endrow)) I've also tried replacing the And joiner with * to no avail. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
nesting sumif functions | Excel Worksheet Functions | |||
SUMIF nesting an AND function | Excel Worksheet Functions | |||
SUMIF nesting ??? | Excel Worksheet Functions | |||
Nesting SUMIF | Excel Discussion (Misc queries) | |||
Nesting of sumif formula. | Excel Worksheet Functions |