help me with sumproduct

[alhassan]

Help.
Which formular do i use to the the "summary" automatically updated, if users' change the month in question?

I tried sumproduct but it seems i didnt do something right

wann868986@gmail.com

 

[Hui]

Summary Sheet F6:
=SUMPRODUCT((Details!$B$5:$B$17=Summary!$C6)*(Details!$E$4:$P$4>DATE(2015,1,1))*(Details!$E$4:$P$4<=EOMONTH(Summary!$D$3,0))*Details!$E$5:$P$17)
copy down

 

[alhassan]

Hello Hui

Thanks a lots for taking the pain to assist me. I really appreciate it.

Your excel formular worked but it distorted the "scrollable list". When i scroll the list "column F" does not move with the list any more because of the new formular inserted in that column.

Please help me with that

Regards

 

[Hui]

Summary F6 should be:
=SUMPRODUCT((Details!$B$5:$B$17=Summary!$C6)*(Details!$E$4:$P$4>DATE(2015,1,1))*(Details!$E$4:$P$4<=EOMONTH(Summary!$D$3,0))*(Details!$E$5:$P$17))
then copy F6 down

I'd left a few $ signs out


ps: Pls don't start new Threads to answer the same question.

 

[alhassan]

Summary F6 should be:
=SUMPRODUCT((Details!$B$5:$B$17=Summary!$C6)*(Details!$E$4:$P$4>DATE(2015,1,1))*(Details!$E$4:$P$4<=EOMONTH(Summary!$D$3,0))*(Details!$E$5:$P$17))
then copy F6 down

I'd left a few $ signs out


ps: Pls don't start new Threads to answer the same question.

Many thanks Hui

Pardon me. I am new to this educative website and i am still learning how it works