Sumif function will sum up your data based on selected criteria (e.g. it sums total paid salaries for each department). Thus, you can avoid using Pivot Table :-)

Try combination of two functions Index and Match to replace Vlookup formula. It is more flexible in terms of columns ordering and you do not need to count the order of the column, you just mark it.

What do we do?

consulting     trainings     e-learnings

What do we uncover?

FUN with OfficeSecret

Don´t you want to miss any tip and trick?

Provide us an e-mail and we will let you know in case we will publish anything special.