David Harrison

Posts: n/a

CountIf Function

HI there

I have a current count IF function that works well. until now.

The range is D4:D9,

Usually it only searches numbers but now i need it to search 8a and 8b as
values. Not the cells.

What is the way around this.

It would be more preferable to seach and add up 8a and 8a as values. (not
the cells 8a and 8b)

Thanks

David

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
using countif function to add only a half of a number	ryanjh79	Excel Discussion (Misc queries)	9	April 26th 23 03:42 AM
clock	Wildman	Excel Worksheet Functions	2	April 26th 05 10:31 AM
How do I use COUNTIF in a SUBTOTAL function to differentiate the .	Lettie	Excel Worksheet Functions	6	March 22nd 05 08:47 AM
Advanced COUNTIF Function	License Boy	Excel Worksheet Functions	3	December 8th 04 02:23 PM
The countif function in Excel 2002.	Lounsbud	Excel Worksheet Functions	1	November 22nd 04 03:19 PM

All times are GMT +1. The time now is 01:35 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us