| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
SUMIF Help
I have columns of data with the date entered in column A
in format MM/DD/YYYY. Column C contains cost data. I am trying to sum up data to the side by month. The formula I tried using is =SUMIF(A3:A38,"MONTH(A3:A38) =1",C3:C38)and =SUMIF(A3:A38,MONTH(A3:A38)=1,C3:C38. Neither method is evaluating the data correctly. Any assistance would be appreciated. TIA, JC |
|
#2
|
|||
|
|||
|
If you'll want to get more than just January's data, I'd strongly
recommend using a Pivot Table, which can organize information by month, quarter, week, etc. See http://peltiertech.com/Excel/Pivots/pivotstart.htm Otherwise, you can use =SUMPRODUCT(--(MONTH(A3:A38)=1),C3:C38) In article , "JC" wrote: I have columns of data with the date entered in column A in format MM/DD/YYYY. Column C contains cost data. I am trying to sum up data to the side by month. The formula I tried using is =SUMIF(A3:A38,"MONTH(A3:A38) =1",C3:C38)and =SUMIF(A3:A38,MONTH(A3:A38)=1,C3:C38. Neither method is evaluating the data correctly. Any assistance would be appreciated. |
| 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 | |||
| 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 | |||
| How do I ask for multiple criteria when creating a "sumif" formul. | Excel Worksheet Functions | |||
| SUM(IF( Array to avoid #NUM! values | Excel Worksheet Functions | |||
Linear Mode
