| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate Revenue based on dates within a month
Hi,
I need help calculating the revenue for the month of August. The date fomat is mm/dd/yy. I have many rows of data. The projecte dates are in Column L and the Factored MRR Revenue is in Column AO. The projected dates are from Jan - Dec. I only need to extract the revenue for the dates in August. Can someone please help me. I've tried using the Sumif formula but I can't figure out how to write the formula to extract dates in August. -- Thanks, Annie |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculate Revenue based on dates within a month
Annie wrote:
Hi, I need help calculating the revenue for the month of August. The date fomat is mm/dd/yy. I have many rows of data. The projecte dates are in Column L and the Factored MRR Revenue is in Column AO. The projected dates are from Jan - Dec. I only need to extract the revenue for the dates in August. Can someone please help me. I've tried using the Sumif formula but I can't figure out how to write the formula to extract dates in August. Something like this: =SUMPRODUCT((MONTH(L1:L100)=8)*AO1:AO100) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculate Revenue based on dates within a month
I received a #VALUE! error
-- "Glenn" wrote: Annie wrote: Hi, I need help calculating the revenue for the month of August. The date fomat is mm/dd/yy. I have many rows of data. The projecte dates are in Column L and the Factored MRR Revenue is in Column AO. The projected dates are from Jan - Dec. I only need to extract the revenue for the dates in August. Can someone please help me. I've tried using the Sumif formula but I can't figure out how to write the formula to extract dates in August. Something like this: =SUMPRODUCT((MONTH(L1:L100)=8)*AO1:AO100) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculate Revenue based on dates within a month
Annie wrote:
I received a #VALUE! error Make sure that there are actually dates in column L, not text that looks like a date. Otherwise, post your formula and some of the data. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculate Revenue based on dates within a month
you're right, I was using the wrong data range... LOL Thanks!!
-- "Glenn" wrote: Annie wrote: I received a #VALUE! error Make sure that there are actually dates in column L, not text that looks like a date. Otherwise, post your formula and some of the data. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculate a date based on specified day of the month | Excel Discussion (Misc queries) | |||
| Calculate month & year in between two dates | Excel Worksheet Functions | |||
| Calculate month & year in between two dates | Excel Worksheet Functions | |||
| Every Month Revenue | Excel Discussion (Misc queries) | |||
| Calculating revenue per month by aggregating dates | Excel Worksheet Functions | |||
Linear Mode
