Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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!! |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
aprendiz wrote:
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!! Something like this: =SUMPRODUCT((LEFT(A1:A8,1)="F")* (--(RIGHT(A1:A8,3))<=20)* (--(RIGHT(A1:A8,3))=1)* (--(RIGHT(A1:A8,3))<10), D1:D8+E1:E8+F1:F8) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Count multiple cells against multiple criteria in an Excel spreads | Excel Worksheet Functions | |||
match multiple criteria ina range from multiple criteria multiplet | Excel Worksheet Functions | |||
Index & Match functions - multiple criteria and multiple results | Excel Worksheet Functions | |||
Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions |