Creating Complex Formulas

I am attempting to create a self servicing spreadsheet that will pull and calculate data contained on another page.

The data included will be number created, number rejected, and the accuracy. The accuracy is not hard for me to figure out, my problem lies in pulling the other data.

Here is the scenario, there are 40 people, who submit work, upon going through it, I will list the day it was created, who the owner was and if it was rejected or not. Each person has their own section to list this data on a daily basis

The first formula I know needs to somehow be an =if(cells=name) but I need to somehow work this to where it will count their names to give the total number created, but also have an If function that includes the date that will give us the total number on a daily basis.

The second formula will need to be much the same, but with an addition of the numbers rejected by each person on a daily basis.

Any help would be greatly appreciated, this has got me stumped

HI


Try SUMPRODUCT

1) =sumproduct(--(range = name),--(range = date)) - this should give you a count of name / date

2) =sumproduct(--(range = name),--(range = date),(reject range)) - this will give you a sum of the rejects by name / date


hth


rylo

I'll give it a try and post back if it doesn't work. Thanks for your help

I tried the formula listed above to no avail, maybe has to do with pulling the data from a seperate page.

I even tried =if(range="date", "count(cell range="Name"),"")

But even that wouldn't work...Any other ideas anyone?

Hi

Can you give more details on your structure, or perhaps a sample file showing a representative structure, example and what you would expect to return for that example.


rylo

I ended up having to use a CONCATENATE formula...Someone showed me that one, I had never heard of them, but it proved very useful in pulling the data