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()
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
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()
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.
I'm sorry but I don't see the attachment. You need to click the "Go Advanced" button to attach a spreadsheet.
Bookmarks