| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Conditional SUMIF
I am currently using the formulae to clcualte the sum for $A5
=SUMIF(JAN_05'!$C$2:$C$65536,$A5,JAN_05'!J$2:$J$65 536) I would to modify this so it leaves out all numbers less than 0 Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Summing (Sumif? Countif?) | Excel Worksheet Functions | |||
| copy the conditional sum (SUMIF) formula | Excel Worksheet Functions | |||
| adding summed cells in a conditional sumif | Excel Worksheet Functions | |||
| HOW DO I COPY A CONDITIONAL SUM (sumif) AND EDIT IT? (THE SUM NEV. | Excel Worksheet Functions | |||
| Conditional Format With SUMIF | Excel Worksheet Functions | |||
Threaded Mode
