I'm trying to create a SUMIFS formula by getting data based on unique cell values.
The following formula grabs what I need but instead of "=BNG0726" I would like to use a value in a cell so that the formula changes based on an entered value.
Also I would like to add a date criteria the same way. For example if date is greater or equal to a value in a particular cell and less than or equal to a value in another cell it will grab the data in cell DATA K1:K100000.
Here's my formula below. It grabs the data I need but would have to be manipulated to reference the correct account code. Also I couldn't get the date criteria to work.
=SUMIFS(DATA!$K$1:$K$100000,DATA!$B$1:$B$100000,">629999",DATA!$B$1:$B$100000,"<640000",DATA!$A$1:$A$100000,"=BNG0726")
Thanks for your help
Here's my attempt to add date criteria but it didn't produce the correct result.
=SUMIFS(DATA!$K$1:$K$100000,DATA!$B$1:$B$100000,">629999",DATA!$B$1:$B$100000,"<640000",DATA!$A$1:$A$100000,"=BNG0726",DATA!$D$1:$D$100000,"">="&DATE(4/1/2012)",DATA!$D$1:$D$100000,""<="&DATE(3/31/2013)")
Bookmarks