You can use the SUMIFS function:
=SUMIFS('5-8-13'!$T$2:$T$5000,'5-8-13'!$T$2:$T$5000,"<1E100",'5-8-13'!$E$2:$E$5000,"Americas",'5-8-13'!$H$2:$H$5000,Americas!D$6)
You can use the SUMIFS function:
=SUMIFS('5-8-13'!$T$2:$T$5000,'5-8-13'!$T$2:$T$5000,"<1E100",'5-8-13'!$E$2:$E$5000,"Americas",'5-8-13'!$H$2:$H$5000,Americas!D$6)
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks