Hi
You can try this in H9
=SUM(SUMIFS(INDIRECT(H5&"!d4:d100"),INDIRECT(H5&"! b4:b100"),B3,INDIRECT(H5&"!e4:e100"),{"walk","fast walk"}))
Hi
You can try this in H9
=SUM(SUMIFS(INDIRECT(H5&"!d4:d100"),INDIRECT(H5&"! b4:b100"),B3,INDIRECT(H5&"!e4:e100"),{"walk","fast walk"}))
Cheers !
Excel Range to BBCode Table
Use Social Networking Tools If You Like the Answers !
Message to Cross Posters
@ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)
Posting Permissions
Reply With Quote
Bookmarks