I would like to populate Sheet1 with info from the drop down lists in Sheet2. When an Incident is selected on a drop list in Sheet2, I need it to enter the total number of occurrences under the proper date and Incident in Sheet1. Please see example.
Any suggestions are very appreciated, Thanks!
-Luke
Last edited by LukeM82; 08-12-2016 at 01:58 PM.
Try the formula below in B3, then fill it down and right:
=COUNTIFS(Sheet2!$A$2:$A$18,B$2,Sheet2!$B$2:$B$18,$A3)+COUNTIFS(Sheet2!$A$2:$A$18,B$2,Sheet2!$C$2:$C$18,$A3)+COUNTIFS(Sheet2!$A$2:$A$18,B$2,Sheet2!$D$2:$D$18,$A3)+COUNTIFS(Sheet2!$A$2:$A$18,B$2,Sheet2!$E$2:$E$18,$A3)
Note that it's designed based on what you have, so if you plan to go beyond row 18 on sheet2 with your dates, change all of the $18s in the formula to something bigger (be sure to change them all to the SAME bigger number, though).
Thank you so much, I think this is exactly what I needed!
My pleasure, good luck!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks