| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumproduct
I am using this function: =sumproduct((month(B5:B412)=1*D5:D412)
I can't get this function to work with Feburary, March....ect. Basically I want "if B5:B412's date is January then add the cells in D5:D412 with the sum the D cells "answer" in cell E2" Same with February, only answer in F2 Same with March, only answer in G2 What am I doing wrong? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sumproduct
You're very close, just missing a couple parenthesis.
=SUMPRODUCT((MONTH(B5:B412)=1)*(D5:D412)) HTH, Elkar "RGlade" wrote: I am using this function: =sumproduct((month(B5:B412)=1*D5:D412) I can't get this function to work with Feburary, March....ect. Basically I want "if B5:B412's date is January then add the cells in D5:D412 with the sum the D cells "answer" in cell E2" Same with February, only answer in F2 Same with March, only answer in G2 What am I doing wrong? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sumproduct
Thank you very much. It worked.
"Elkar" wrote: You're very close, just missing a couple parenthesis. =SUMPRODUCT((MONTH(B5:B412)=1)*(D5:D412)) HTH, Elkar "RGlade" wrote: I am using this function: =sumproduct((month(B5:B412)=1*D5:D412) I can't get this function to work with Feburary, March....ect. Basically I want "if B5:B412's date is January then add the cells in D5:D412 with the sum the D cells "answer" in cell E2" Same with February, only answer in F2 Same with March, only answer in G2 What am I doing wrong? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need help with sumproduct and dynamic ranges | Excel Worksheet Functions | |||
| sumproduct causing memory errors? | Excel Worksheet Functions | |||
| Can I reference =, <, or > sign in SUMPRODUCT | Excel Discussion (Misc queries) | |||
| Sumproduct function not working | Excel Worksheet Functions | |||
| adding two sumproduct formulas together | Excel Worksheet Functions | |||
Linear Mode
