Sum of similar values in a column

[Zilimax]

I have two worksheets, one contains the dashboard and the other contains the data. On the one with the data, there is a column with a drop down menu of 'pass/fail'. Now I need two rows on the dashboard that is able to give a total of 'pass and fail' If I make sense.

[xladept]

Attach 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 then scroll down to Manage Attachments to open the upload window (or use the paperclip icon).

[Tony Valko]

Assuming your data is in column A on a sheet named Data.

Data Range

	A	B
1	Pass	7
2	Fail	6
3	------	------

Enter this formula in B1 and copy down:

=COUNTIF(Data!A:A,A1)

[gmr4evr1]

If the column with the pass fail drop down menu is in A, try this in the cell you want the count to show in for pass...

Please Login or Register  to view this content.

and this in the cell you want the count for fail

Please Login or Register  to view this content.

Change A$1:A$6 to the range you drop-downs are in

[shirleyxls]

Hi

On your dashboard you need formulas like this:

=COUNTIF(Data!$D$2:$D$7,"Pass")
=COUNTIF(Data!$D$2:$D$7,"Fail")

Set the range to whatever is on your data sheet

You could also add 2 labels on your Dashboard, then check these instead of putting the Pass/Fail in the formula. So if you had "Pass" in cell A1 on your dashboard, you would put:

=COUNTIF(Data!$D$2:$D$7,A1)

You can do the same for Fail


Excel is a constant learning process and it's great to help each other. If I've helped you today, a click on the star on the left is appreciated.

[Zilimax]

pnt1.jpgpnt2.jpg

This is the screenshot.
Dashboard explains it.

I also need help with column G in pnt2.

Thanks

[Zilimax]

pnt1.jpg, pnt2.jpg

This is the screenshot.
Dashboard explains it.

I also need help with column G in pnt2.

Thanks

[Zilimax]

pnt1.jpg, pnt2.jpg


This is the screenshot.
Dashboard explains it.

I also need help with column G in pnt2.

Thanks

[shirleyxls]

Are you able to upload a sample of your workbook?

Screenshots are a bit difficult to understand and work with

Thanks

[Zilimax]

sent you the file.

[shirleyxls]

Thanks for the workbook, that made it much easier

Put the following formula in G3, then copy it down:

=IF(E3="YES","Fail",IF(E3="NO","Pass",""))

This puts in the required outcome as you describe, but leaves it blank if E3 is empty.

By the way, did you know that you have auto calculation switched off in the spreadsheet? It confused me for a minute because I got no results when I put the formula in! I had to press F9 to manually calculate.