Hello,
I need some assistance to this basic query. I have dates (Col A) which has some repetitive dates and Col B has a priority.
I need to add up the priorities for each new dates. Any suggestions would be helpful. Pl. note I am newbie to Excel.
See the attachement. for clarification.
Try this in E8:
Formula:
Please Login or Register to view this content.
Drag down and across
Hope this helps
A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
-Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
-To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
If you received helpful response, please remember to hit the * of that post
Hi kri54sub
Try the SUMPRODUCT as you uploaded a xls file.
In E8 copy across and down:
Formula:Please Login or Register to view this content.
Regards Kevin
Merged Cells (They are the work of the devil!!!)
Thanks to all the reponses. Your suggested solutions worked.
--
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks