Formula Help

legion4weare1

New member
Joined
Apr 30, 2013
Messages
5
Reaction score
0
Points
0
Hi There

I need a formula that is going to pull data from two seperate raw data sheets, the formula needs to do the following:


  • recognise a persons name
  • recognise the date
  • count the amount of cells that show a persons name against a specific date and multiply by 10 on one sheet and then add that to a total figure assigned in another sheet against the same name and date

Any help would be appreciated :)

Thanks
 

Simi

New member
Joined
Feb 10, 2012
Messages
190
Reaction score
0
Points
0
Location
Utah, USA
Excel Version(s)
Version 2002 Build 12527.20194
can you please upload a workbook with dummy information, that has the format of what you are trying to do.
a short answer would be use a countif()
 

Simi

New member
Joined
Feb 10, 2012
Messages
190
Reaction score
0
Points
0
Location
Utah, USA
Excel Version(s)
Version 2002 Build 12527.20194
if you have your list of names in column A, and dates in column B.
=COUNTIFS(A1:A??,"="&??,B1:B??,"="&??)
replace the ?? with the ending ranges, or the name/date you want to check against.

hope this gets you going.
 

legion4weare1

New member
Joined
Apr 30, 2013
Messages
5
Reaction score
0
Points
0
reply with attachment

can you please upload a workbook with dummy information, that has the format of what you are trying to do.
a short answer would be use a countif()

I have attached a spreadsheet in the first tab ignore actual worked column (column G)

Thanks for the help
 

Simi

New member
Joined
Feb 10, 2012
Messages
190
Reaction score
0
Points
0
Location
Utah, USA
Excel Version(s)
Version 2002 Build 12527.20194
I'm sorry but I don't see the attachment. You need to click the "Go Advanced" button to attach a spreadsheet.
 
Top