Perhaps something along these lines:
In B1 across: January, February ...
In A2 down: Names of staff
Then in B2, copied across and filled down to populate:
=Sumproduct((Staff=$A2)*(Month=B$1),Procedures)
where Staff, Month, Procedure would be identically structured defined ranges
referring to the relevant source data
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"SCarleton" wrote:
I am trying to nest sumif function with no luck.
I have a table of data with several columns.
I need to look at the month column first and see if it's "January", then
look at the "name" column to see if a specific person performed the
procedures in that month, then finally add the number of procedures this
person performed in January.
I want to have a Data sheet that contains all this information, then without
using pivot tables set up a permanent spreadsheet that puts names of people
as rows and months as column headers, then the number of procedures as the
data.
Can anybody help ?