Forum Discussion
Column Pull Based on General Search
Hi Mike,
As Detlef mentioned better to use SUMIFS, you have to have it if your version of Excel is 2007 or later.
In your case it will looke like
=SUMIFS(B:B, D:D, "Cookies", C:C, ">=" & <min date>, C:C, "<=" & <max date>)
if your dates are in C:C and you will use actual references on min and max dates
Hi Mike
A job or SUMIF() oder SUMIFS() or a Pivot Table.
Hi Detlef,
So I wrote =sum(if($D$2:$D$5000="Cookies",$E$2:$E$5000,0)) then locked it, and it pulled like I needed, now the next step that I just realized, that I forgot to mention, is how to get it also pull from certain date ranges.
Hi Mike,
As Detlef mentioned better to use SUMIFS, you have to have it if your version of Excel is 2007 or later.
In your case it will looke like
=SUMIFS(B:B, D:D, "Cookies", C:C, ">=" & <min date>, C:C, "<=" & <max date>)
if your dates are in C:C and you will use actual references on min and max dates
- Just to add to this, if you don't want to edit this formula each time you use it, you can add two cells that include the minimum date and maximum date, then reference those cell sin Sergei's formula above. That way your formula will always be correct and all you need to change is the min and max dates that you want to be reflected in the calculation.
