Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I am loking for a piece of code for the following. I have 100 rows and 39 columns. Every row could be in 3 different ways: A B C D E F G H I..............AM 1 0 0 0 100 150 65 85 73 25............89 2 0 0 0 56 130 125 88 178 32...........0 3 98 36 58 89 489 125 88 178 32...........56 I need to sum the first 6 cells with numbers or sales (no with 0's), and those first 6 numbers for every row could start at any colums of those 39 columns. Example row 1 should sum from D to I, row 2 should sum from D to I, row 3 from A to F. I am not sure how to start Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
SUMIF | Excel Worksheet Functions | |||
sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A" | Excel Worksheet Functions | |||
Embedding a Sumif in a sumif | Excel Worksheet Functions | |||
nested sumif or sumif with two criteria | Excel Worksheet Functions | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions |