Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am trying to have cell in colum A summed IF the corresponding cell in colum
B is the same as a specific cell D4. Data looks like this. Data to be summed If cells here are the same as The cells here 55 1 0 5 0 1 5 1 2 3 0 3 32 0 4 88 0 5 My forumla looks like this, but it keeps returning Zeros. =SUMIF(M$8:M$1051,"=I8",L$8:L$1051) What am I doing wrong? Something is wrong with the "=I8" piece. thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Cell References | Excel Discussion (Misc queries) | |||
Adding a row to worksheet does not update cell references in another. | Excel Worksheet Functions | |||
Function to add multiple "."s with a cell? | Excel Worksheet Functions | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
using multiple split cell references in linest | Excel Worksheet Functions |