I have two data sources in a dashboard - one has slicers. Some data on the dashb needs a sumifs formula (or other if better) that can include a cell reference that is generated by the slicer (Member and Date)
Only the month is necessary for the report so if dates are incompatible can they also be wildcarded?
the attached review dashboard workbook has data for two people for two months with slicers.
Any help is greatly appreciated.
Jim
SUMIFS doesn't play so well with nested functions, so we can fall back on SUMPRODUCT.
It essentially does the same thing in a slightly more roundabout way.
The only thing it doesn't handle quite as well are undeclared row or columns such as A:A or 1:1, so we limit the search field to something reasonable. (I went with 110 rows; use what's applicable.)
=SUMPRODUCT((TEXT('Daily Stat'!$A$2:$A$110,"mmm")=R8)*('Daily Stat'!$B$2:$B$110=R9)*('Daily Stat'!$C$2:$C$110))
For the other cells, just adjust the column reference of the value array ('Daily Stat'!$C$2:$C$110) to what you're looking for.
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks