Hi
I am looking for a formula in the summary table which adds all the tabs together with multiple criteria.
for example
Tabs 1 2 3 4
Summary Table:
Flight: az201 should give me give me 4 as the number 5 occurs 4 times in the sheet 1, 2 ,3 4
Please see attached
Are we to count "Delay Code 1" and "Delay code 2" and "Flights In" and "Flights Out": are these related?
This will count "Flights In"/"Delay code 1"
=SUMPRODUCT(COUNTIFS(INDIRECT("'" &Sheets & "'!A3:A7"),$A4,INDIRECT("'" &Sheets & "'!F3:F7"),E$3))
Sheets is named range of your sheet names.
Last edited by JohnTopley; 12-08-2016 at 05:41 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks