Hi,
I have excel sheet Sheet1(data is spreaded on whole where data is like....
Activity Number Date1 Date2 Date3 Date4 Date 5 Date6
AN1 3 3
AN2 4 2
AN1 8
AN3 3
AN4
AN2 1 1
AN3 2
.
.
.
In sheet 2 Sheet2 I want to display data like....
Activity Number Total number
AN1 14
AN2 8
AN3 5 i.e total number for a specific activity .
How can I do this?
Hello,
welcome to the forum. If you could please post the sheet in question it will make it much easier to answer your question.
STOP! CONTINENTAL DRIFT.
Try Sumproduct()
e.g.
=Sumproduct((Sheet1!$A$2:$A$100=A2)*(Sheet1!$B$2:$G$100))
adjust sheetname and ranges to suit.
P.s. Please don't use words like Urgent in your titles... we answer questions as we see them and are able to answer them.. not based on urgency
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks