Hi all, this is a quick question, as i forgotten the last part of the formula i am trying to create.
this formula works:
=SUMPRODUCT((Database!$A$1:$SQ$1=$B5)*(Database!$A$1:$A$600>=$C$2)*(Database!$A$1:$A$600<=$E$2)*(Database!$A$2:$SQ$2=Sheet1!C$3))
However it is given me a total "Count" of items.
I need this to be the criteria and then sum a different cell.
So if the above criteria is meet then sum these. Make sence.
Bookmarks