Excel 2007: Adding up number of appointments

BenHoughton

New Member
Joined
Mar 26, 2013
Messages
5
Hi all,

I've created the following:

=SUM(COUNTIF($H5:$U199,"PA")+COUNTIF($H5:$U199,"K")+COUNTIF($H5:$U199,"MA")+COUNTIF($H5:$U199,"MR")+COUNTIF($H5:$U199,"TW"))

which doesn't give me any error when I set it under conditional formatting. I only place this in the cell where I wish the data to be displayed.

I've used H5 as the first cell where the data comes from and U199 is the last cell in the sheet.
PA, K, MA, MR and TW are options from a drop down list that I created. I need these to be counted and displayed in the cell where I have applied the above formula.

However, I get no 'display' of number at all when I use this formula so I'm a little stuck as to what I'm doing wrong? The cell just stays blank when data is inserted to the worksheet.

Any ideas what I'm doing wrong please?
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
The formuls seem to work which means there are none of these letters there,

one reason for this is there may be a space on the cell try selecting one of these letters in the table and pressing F2 to see if there
is a space or 2 before it.
 
Upvote 0
No worries, I fixed it. Instead of putting it in conditional formatting I put it as a function and removed the =sum bit from the start. One of those 'i dont understand the reasoning behind it but it works' :)

Thanks for the quick response anyway :)
 
Upvote 0

Forum statistics

Threads
1,203,618
Messages
6,056,320
Members
444,858
Latest member
ucbphd

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top