Count values from cells depending on drop down selection

**metch** · 02-12-2016, 02:22 PM

Hello Guys,

I have a sheet (sheet A) with a drop down that populates a report feeding from another sheet (sheet b) using data validation. On sheet A I keep track of the amount hours I spent daily on a project. but I need help finding a way for Sheet B to keep a track of the total amount of hours spent on every project monthy based on how many hours are used on Sheet A. (Please consider the projects on Sheet A are never populated in order.)
I've attached a couple of screenshots to help explain what I'm looking for.

**Kaper** · 02-15-2016, 08:32 AM

Probably simple SUMIF formula would do the trick. If not, consider attaching a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Count values from cells depending on drop down selection

LinkBack

Thread Tools

Rate This Thread

Display

Count values from cells depending on drop down selection

Re: Count values from cells depending on drop down selection

Thread Information

Users Browsing this Thread

Similar Threads

Compare values from 2 tables and return total sum depending on drop down menu selection

Applying Certain Formulas depending on Drop Down Selection

How to generate drop-down that subsequently displays/hides cells depending on selection

Make a box appear / disappear depending on drop down form selection

Make a box appear / disappear depending on drop down form selection?

Changing cell values depending on drop down selection

Auto fill cells depending on Drop down List selection

Bookmarks

Bookmarks

Posting Permissions