I still don't get it.
Where you:
?select a criteria in column A and B (egg "01" and "1. TRADE")
I still don't get it.
Where you:
?select a criteria in column A and B (egg "01" and "1. TRADE")
Never use Merged Cells in Excel
The trick here is to replace the sumifs from excel2007 by something like sumproduct.
Dashboard v3.2.xls
Example:
I want to sum col Y (O30) if 3 conditions are here
- Col A="01"
- Col B="A"
- Col C=dynamic cell B1 in the tab CALC
I hope I'm clear enough
I found the solution!
=SUMPRODUCT(--('AR Tracking'!$A$3:$A$10000="01");--('AR Tracking'!$B$3:$B$10000="1. TRADE");--('AR Tracking'!$C$3:$C$10000=CALC!BB1);'AR Tracking'!$Y$3:$Y$10000)
Thanks to this youtube tutorial:
https://www.youtube.com/watch?v=vxpeEf8MYaY
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks