| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Thanks I'll try that.
Anat "bj" wrote: temporarily add a helper column Y in your P&L... sheet enter in Y10 =if(X10="P",1,"") copy down to X152 look in column X for "P"s which do not have a 1 next to them. You should be able to identify what is the difference modify your equation in column Y until you get a perfect correlation. "Anat" wrote: =SUMIF('P&L Cat(YTD May) '!$X$10:$X$152,"P",'P&L Cat(YTD May) '!$C$10:$C$152) Anat "Harlan Grove" wrote: Anat wrote... The criteria is a text not a number. .... What's your actual formula? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
| Dynamic sumif function | Excel Worksheet Functions | |||
| sumif alphanumeric problems | Excel Discussion (Misc queries) | |||
| SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions | |||
| help with "criterea" in the sumif function | Excel Worksheet Functions | |||
Hybrid Mode
