Hi all,
I am using following formula for one of my projects.
=SUMPRODUCT(--('Air Data'!F:F=ABZA!$A$1),--('Air Data'!G:G=ABZA!A11),--('Air Data'!B:B>=ABZA!$B$3),--('Air Data'!B:B<=ABZA!$B$4),--('Air Data'!L:L="OD"),'Air Data'!N:N)
At present, I have one column showing above formula and I want to add a column with total excluding "OD" or something like not equal to "OD.
Please can someone urgently help.
Many thanks,
Taashi
I am using following formula for one of my projects.
=SUMPRODUCT(--('Air Data'!F:F=ABZA!$A$1),--('Air Data'!G:G=ABZA!A11),--('Air Data'!B:B>=ABZA!$B$3),--('Air Data'!B:B<=ABZA!$B$4),--('Air Data'!L:L="OD"),'Air Data'!N:N)
At present, I have one column showing above formula and I want to add a column with total excluding "OD" or something like not equal to "OD.
Please can someone urgently help.
Many thanks,
Taashi