IF formulas

[Guest]

I have never created an If formula, but I assume that it is what I need. Here is what I am trying to do -
I have a spread sheet with 4 worksheets
The first page I have a column where I put the business managers initials and the following columns have info about production and sales
The second worksheet I want it to pull all of RS's info and place it in summary for that particular person
The third Worksheet is the same concept only with JB's info
The last worksheet I am using as a "team summary" and I can do that one
How do I get the 2nd & 3rd sheets to separate between RS & JB?

 

[Frank Kabel]

Hi
you may explain your data in your first sheet a little bit more (give
some example rows). Also explain your summary page (all plain text - no
attachment please)

I'd assume something like sUMIF, COUNTIF or SUMPRODUCT could do.
But also pivot tables could be a valid solution