| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
sumif with different rows won't work!?
Trying to do a sumif but not all in the same row. I want to sum row 2 and 4 and divide it by sum of row 1 and 3, but only if cells in row 2 and 4 have numbers in them.
A row 1 100 10 row 2 50 2 row 3 100 10 row 4 25 2 So, =sum(a2:b2,a4:b4)/sumif(a2:b2,a4:b4,"0",a1:b1,a3:b3 But it won't do because of the , between b1 and a3. Help! Thank You. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sumif to work with times along a row | Excel Discussion (Misc queries) | |||
| SumIf will not work in this case | Excel Discussion (Misc queries) | |||
| SUMIF Won't Work for Me | Excel Worksheet Functions | |||
| Need Countif to work like Sumif | Excel Worksheet Functions | |||
| enter doesn't work with sumif | Excel Worksheet Functions | |||
Threaded Mode
