Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum if - month question
I am using the following formula (and it works!) to calculate the number of
dates that equal january, feb, and so on. =SUMPRODUCT(--(MONTH('Raw Data'!H$4:H$18)=1)) Within the raw data, I also have the word "unscheduled" where a date should belong. I am now getting errors with my formula. How do I add - if the cell doesn't = unscheduled, then sum product? Thanks!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum if - month question
One way:
=SUMPRODUCT(--(TEXT('Raw Data'!H4:H18,"mmm")="Jan")) Biff "paula k" wrote in message ... I am using the following formula (and it works!) to calculate the number of dates that equal january, feb, and so on. =SUMPRODUCT(--(MONTH('Raw Data'!H$4:H$18)=1)) Within the raw data, I also have the word "unscheduled" where a date should belong. I am now getting errors with my formula. How do I add - if the cell doesn't = unscheduled, then sum product? Thanks!! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum if - month question
Try this
=SUM(IF(ISNUMBER(H$4:H$18),IF(MONTH(H$4:H$18),1))) as an array formula, commit with Ctrl-Shift-Enter rather than just Enter -- --- HTH Bob (change the xxxx to gmail if mailing direct) "paula k" wrote in message ... I am using the following formula (and it works!) to calculate the number of dates that equal january, feb, and so on. =SUMPRODUCT(--(MONTH('Raw Data'!H$4:H$18)=1)) Within the raw data, I also have the word "unscheduled" where a date should belong. I am now getting errors with my formula. How do I add - if the cell doesn't = unscheduled, then sum product? Thanks!! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum if - month question
One way:
=SUM(IF(ISNUMBER('Raw Data'!H$4:H$18),--(MONTH('Raw Data'!H$4:H$18)=1))) This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it correctly, excel will wrap curly brackets {} around your formula. (don't type them yourself.) paula k wrote: I am using the following formula (and it works!) to calculate the number of dates that equal january, feb, and so on. =SUMPRODUCT(--(MONTH('Raw Data'!H$4:H$18)=1)) Within the raw data, I also have the word "unscheduled" where a date should belong. I am now getting errors with my formula. How do I add - if the cell doesn't = unscheduled, then sum product? Thanks!! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
12 Month Average | Excel Worksheet Functions | |||
Dates Formatting Question - What if you do not know month and/or d | Excel Discussion (Misc queries) | |||
How to create a rolling 6 month average? | Excel Discussion (Misc queries) | |||
End of Month question | New Users to Excel | |||
Month Year Date Format | Excel Worksheet Functions |