Hi,
I need help in solving the SumProduct formula based on multiple criteria
Start Date
End Date
Acct. No
Font Colour
Hi,
I need help in solving the SumProduct formula based on multiple criteria
Start Date
End Date
Acct. No
Font Colour
Hi,
Try this function
NamePlease Login or Register to view this content.
B41 'dtStart'
B42 'dtEnd
G42 'fontcolour
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
Try this in C43 thendragged across
=SUMPRODUCT(((A2:A37<=B41)+(A2:A37>=B42))*(E2:E37=B43)*F2:F37)
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
hi Richard,
How can get the result using you Function
Try this in C43 thendragged across
=SUMPRODUCT((($A$2:$A$37<=$B$41)+($A$2:$A$37>=$B$42))*($E$2:$E$37=$B43)*F2:F37)
Last edited by kvsrinivasamurthy; 11-22-2018 at 11:11 AM.
I think this is what you need:
=SUMPRODUCT(--($A$2:$A$37>=$B$41)*($A$2:$A$37<=$B$42)*($E$2:$E$37=$B43)*TestFont($F$2:$F$37,$G$42)*F$2:F$37)
in C43, copied across and down.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Put the Function in a VBA Module.
Alt-F11 to go to VBA, find your workbook in the VBA Project window on the left, choose one of the objects - a sheet or the workbook object and from the menu choose Insert Module and copy the code I gave.
Then in the worksheet treat that function as a normal Excel function and enter
Formula:Please Login or Register to view this content.
See workbook attached
Last edited by Richard Buttrey; 11-22-2018 at 12:43 PM.
Hi Glenn,
Thanks, at present I am out of office. I will check and get back.
Thank you Richard & Glenn, excellent. Solved..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks