Posts: n/a

countif, sumproduct

table:
1.5.2006 blue
2.5.2006 green
30.4.2005 green
21.5.2006 yellow
21.6.2006 blue

how can I count all the green guys with the datum after 1.5.2005?
countif will not probably work...

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 or SUMPRODUCT counting multiple criteria	Kim	Excel Worksheet Functions	1	June 1st 05 12:19 AM
COUNTIF or SUMPRODUCT counting multiple criteria	Peo Sjoblom	Excel Worksheet Functions	0	May 31st 05 11:40 PM
Using COUNTIF with 2 criteria - SUMPRODUCT?	Mike R.	Excel Worksheet Functions	2	February 24th 05 05:57 AM
SUMPRODUCT & COUNTIF	Connie Martin	Excel Worksheet Functions	2	December 16th 04 06:53 PM
adding two sumproduct formulas together	ski2004_2005	Excel Worksheet Functions	1	November 12th 04 09:08 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us