Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumproduct & cells containing " "?
Excel2003 ... I am comparing 3 criteria ... WS2 Cols D-E-F to WS1 Cols A-B-C
.... when there is a match I wish to Sum values in WS2 Col G & return value to WS1 Col D ... I am using Sumproduct & Formula is working fine except when " " is found in the WS2 Col G to be summed. When this happens my formula returns the #Value error ... If I replace the " " with "0" then formula again works fine ... Above said ... How do I write Sumproduct so it will ignore the cells in the Col being summed when they contain a " "? Thanks for the guidance ... Kha |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
SUMPRODUCT(--ISNUMBER(FIND("AM",C5:160))*(k5:k160="") | Excel Discussion (Misc queries) | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Sumproduct formula "breaks" when referencing too many cells, why? | Excel Discussion (Misc queries) |