Hi All,
I would like to create a custom data validation formula but am unsure of how to complete this.
In more detail I am using a SUMIFS formula at the moment to use the list reference box to identify particular items from a table, the drop down box being in cell C4.
'=SUM(SUMIFS('SBI Data Air'!$X:$X,'SBI Data Air'!$P:$P,$A8,'SBI Data Air'!$K:$K,$B8,'SBI Data Air'!$AJ:$AJ,E$7,'SBI Data Air'!$AK:$AK,'Volume - KGS - IE AIR'!$E$4))'
Is it possible to use a formula instead where I can also the add the option to sum anything with both CC & PP listed in my table?
Many thanks,
Gaz
Bookmarks