Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup to multiple rows and columns
I have an spreadsheet with columns like:
col A col D col E colF B230 8 1 0 F001 -5 0 10 F002 3 20 0 F010 5 -29 3 F014 40 3 7 F020 -25 -6 -100 F113 0 0 0 H002 34 -50 23 in ascendent order. I want to be able to Sum col D to colF if colA is between F001 and F020 except F010. I am just starting with this and I really don't know how to mix and match all the formulas. any help will be much appreaciated!! Thanks in advance. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup to multiple rows and columns
See reply in microsoft.public.excel.misc
And please don't post the same question multiple times in different newsgroups - you can post to multiple newsgroups simultaneously, if need be, so that an answer in one newsgroup propagates to all. -- Cheers macropod [Microsoft MVP - Word] "aprendiz" wrote in message ... I have an spreadsheet with columns like: col A col D col E colF B230 8 1 0 F001 -5 0 10 F002 3 20 0 F010 5 -29 3 F014 40 3 7 F020 -25 -6 -100 F113 0 0 0 H002 34 -50 23 in ascendent order. I want to be able to Sum col D to colF if colA is between F001 and F020 except F010. I am just starting with this and I really don't know how to mix and match all the formulas. any help will be much appreaciated!! Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using lookup function on multiple rows and columns | Excel Worksheet Functions | |||
Find a value Using a lookup table multiple columns and rows | Excel Worksheet Functions | |||
Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
Lookup in Multiple Columns, Return Multiple Values | Excel Worksheet Functions |