Home |
Search |
Today's Posts |
#1
|
|||
|
|||
>< formulas
A spreadsheet containing two colums. Column A has dollar amount entries.
Column B has date entries. These entries are entered throughout the month and every month of the year. I need a formula that will sum the amounts in column a only if they are during the month of march from column b (for example) |
#2
|
|||
|
|||
"mpiton" wrote in message ... A spreadsheet containing two colums. Column A has dollar amount entries. Column B has date entries. These entries are entered throughout the month and every month of the year. I need a formula that will sum the amounts in column a only if they are during the month of march from column b (for example) I think you want SUMIF http://www.techonthenet.com/excel/formulas/sumif.htm /Fredrik |
#3
|
|||
|
|||
Put this is C1 and copy down..........
=IF(MONTH(B1)=$D$1,A1,"") In D1, type the 3 for March, or 4 for April, etc........ In E1 put this formula, =SUM(C:C) Vaya con dios, Chuck, CABGx3 "mpiton" wrote in message ... A spreadsheet containing two colums. Column A has dollar amount entries. Column B has date entries. These entries are entered throughout the month and every month of the year. I need a formula that will sum the amounts in column a only if they are during the month of march from column b (for example) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with named formula's | Excel Worksheet Functions | |||
Formulas | Excel Worksheet Functions | |||
How to make Excel run limited number of formulas on a given worksh | Excel Discussion (Misc queries) | |||
Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |