Posted to microsoft.public.excel.programming

external usenet poster

Posts: 4

I hope someone can help me with a formula

I have a spreadsheet set up and need a formula to count the number of entries
in a row IF another row's criteria matches.
ie: COUNT(IF(B3:IV3,"Excellent"),IF(B1:IV1,"A07C,A06C, A18C)
The problem I'm encountering is that the 'count' formula does't seem to work
with multiple criteria...does anyone have any suggestions?

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
Simple Formula Questions (I hope)	Logues	New Users to Excel	5	May 28th 09 05:36 AM
Hope someone can help me	Jay Blatherwick	Excel Discussion (Misc queries)	1	June 15th 06 06:03 PM
Hope Someone Can Help...	Tom Ogilvy	Excel Programming	0	October 4th 05 12:54 PM
Last Hope -HELP!!	Dick Kusleika[_3_]	Excel Programming	3	July 1st 04 06:33 PM
Last Hope -HELP!!	Bob Phillips[_6_]	Excel Programming	0	June 29th 04 09:08 PM

All times are GMT +1. The time now is 08:49 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us