extracting data from a list

[anillinda]

I have list of data with 4 columns:
1. number identifier: say a1,a2,a3
2. description: say salary, bonus, overtime, misc
3.amount: $500,$100,$200,$250,$25
4.type: sales, admin,shop,

I would like to extract data based on type, say under type, I have a category "sales", I would like a formula that can extract all the data from all 4 columns and populate the new sheet for which the type is "sales".

a1, salary, $500,

appreciate help
Thanks
Ani

 

[Rijnsent]

Hi Ani,
you probably want to look into the SUMIFS formula and/or the COUNTIFS formula.
e.g. =SUMIFS(C2:C5,D2:D5,"sales",B2:B5,"misc")
Cheers,
Koen