Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Querry Range and Add
Hello
My spreadsheet has a variable number of columns from row 19:378. I would like to search the range for the contents of c384, and whenthe criteria is met add the cellst he 'found' cell. It doesnt matter whether this is accomplished by formula or code. Example: A19=Cat B19=Cat A20=10 B20=40 The criteria is Cat found in C384 and the total would be 50 or the total of all occurences in the range where cat is found. Im not sure if I have explained adequately or not but I am having a hard time getting stated on this one. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
querry | Excel Discussion (Misc queries) | |||
Formulae querry | Excel Discussion (Misc queries) | |||
Use two different value to run a querry | Excel Discussion (Misc queries) | |||
MS Querry for Excel | Excel Worksheet Functions | |||
Web Querry question | Excel Discussion (Misc queries) |