hi,
I have 4 selected criteria (data validation list):
column A1 = Region
column C1 = Country
column E1 = Owner
column G1 = Service.
In my data rows region is in column AN, country in column AJ, owner in column AM and service in column AR.
<tbody>
</tbody>example:
user can select only region = EU, region = EU and country = ESP, country = NL and Owner = Nicola etc....for me it`s 14 diffrent cases.
Always I want to get sum (COST, column AA) where COST TYPE= F.
How can I do that?
I have 4 selected criteria (data validation list):
column A1 = Region
column C1 = Country
column E1 = Owner
column G1 = Service.
In my data rows region is in column AN, country in column AJ, owner in column AM and service in column AR.
AN - Region | AJ - Country | AM - Owner | AR -Service | AA - COST | AB - COST TYPE |
EU | NL | Nicola | AFT | 200 | F |
EU | ESP | Tom | AT | 150 | F |
AF | CON | Simom | AFT | 180 | P |
AZ | JP | Chi | AFTX | 230 | F |
<tbody>
</tbody>
user can select only region = EU, region = EU and country = ESP, country = NL and Owner = Nicola etc....for me it`s 14 diffrent cases.
Always I want to get sum (COST, column AA) where COST TYPE= F.
How can I do that?