Sumifs

tlsthevirtualc

New Member
Joined
Sep 14, 2011
Messages
6
In my sumifs formula, the criteria 2 is <=F2 which is a drop down list of weeks. I'm trying to sum the values from the beginning of the series thru the week in F2. The answer comes up 0. If I change criteria 2 to =F2 it will add the values for the week.
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
Hello and welcome to The Board.
Can you give the complete formula, please, together with the value that is in F2?
Which version of Excel is being used?
 
Upvote 0
If you could post the formula that would help, perhaps you need to put "<="F2 rather than <=F2
 
Upvote 0
Here is the formula.

=sumifs (Forecast!N4:N166,Forecast!L4:L166,A8,Forecast!O4:O166,"<=E2")

E2 is a drop down box of weeks. I'm trying to sum thru the week selected in the drop down box. If I manually put in the number it works.

Changing the quotes did not work. Excel 2007

Thanks for your help
 
Last edited:
Upvote 0
I will have a closer check later, but just try:
=SUMIFS(Forecast!N4:N166,Forecast!L4:L166,A8,Forecast!O4:O166,"<="&E2)
 
Upvote 0
When you were using:
"<=E2")
it would have been looking for cells containing the two characters E and 2 instead of the value contained in cell E2.
By using:
"<="&E2
you are joining the condition (<=) with the value contained in cell E2 using a technique known as CONCATENATION. You will find more about this and the CONCATENATE function in Excel Help.
 
Upvote 0

Forum statistics

Threads
1,224,550
Messages
6,179,462
Members
452,915
Latest member
hannnahheileen

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top