Forum Discussion
Solved
Column Pull Based on General Search
Good Morning, I am having trouble trying to get a column to generate totals while referencing the column next to it. I've attached photos to try to help better show the situation as my explan...
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 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.
