Posted to microsoft.public.excel.worksheet.functions

amir2000

external usenet poster

Posts: 13

countifs - what is instead in excel 2000???

Hi
I used in office2007 the function countifs, in office2000 it's not working.
What can i use instead?

Example:

=countifs(AL5:AL29,=39601,AS5:AS29,box*)+countifs( AN5:AN29,=39601,AS5:AS29,box*)+countifs(AP5:AP29,= 39601,AS5:AS29,box*)

- I need to count the date from 3 columns and if its true then to count the
word box(number coming after).

Anyone can help??

Thanks,

Amir

--
www.amir2000.nl

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
translating countifs function to Excel 2003	ridgeback	Excel Worksheet Functions	4	April 29th 08 10:18 PM
Countifs Fx in 07 how in 03?	HenderH	Excel Discussion (Misc queries)	19	March 26th 08 12:37 PM
Excel CountIfs() and SumIfs() question	Harlan Grove	Excel Worksheet Functions	1	September 18th 07 12:12 AM
countifs	Forza MIlan	Excel Discussion (Misc queries)	2	July 4th 07 09:48 AM
2 COUNTIFS	Joey041	Excel Discussion (Misc queries)	1	November 16th 06 08:11 AM

All times are GMT +1. The time now is 10:25 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us