Posted to microsoft.public.excel.misc

stretch

external usenet poster

Posts: 12

COUNTIF Multiple conditions

I have a worksheet were I want to count the number of times a number larger
than 0 appears in the second column 'B', but only if the month is 'May' in
the first column 'A'. I seem to have problems using multiple COUNTIF
conditions, the solution is probably easy but its driving me mad!

A B
1 May 0
2 Feb 0
3 May 15
4 March 40
5 May 50

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
Countif with multiple conditions	torooo	Excel Discussion (Misc queries)	5	December 7th 07 07:03 PM
CountIf multiple conditions	ashg657	Excel Worksheet Functions	2	March 12th 07 08:55 AM
CountIf with multiple conditions	Thor	Excel Worksheet Functions	2	September 22nd 06 08:59 PM
Multiple conditions on a countif	Mr Mike	Excel Worksheet Functions	5	January 24th 06 01:52 PM
COUNTIF using multiple conditions?	Muse of Fire	New Users to Excel	3	December 29th 04 08:49 PM

All times are GMT +1. The time now is 03:02 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us