Posted to microsoft.public.excel.misc

Trev[_2_]

external usenet poster

Posts: 32

Count formula help

I am trying to setup formula that does the following, What did I miss?

if data sheet,column T = k1 and data sheet, column T <=k1 and Data sheet
column B = sold and data sheet column H = *1020

=countifs(Data!T4:T261=k1,Data!T12:T261<=L1)*(Dat a!B4:B261,"sold"),(Data!H4:H227,"*1020")

Thanks for you Help!!

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
Count Formula - Count Ticks	LittleAnn	Excel Discussion (Misc queries)	3	May 8th 23 07:44 PM
Trying to construct a count count formula	Chris K	Excel Discussion (Misc queries)	6	May 26th 07 07:20 PM
Count formula help!!	Beginner	Excel Discussion (Misc queries)	7	December 28th 06 04:52 PM
Count Formula	ceej	Excel Worksheet Functions	6	July 18th 06 12:02 AM
Count formula	Vibha	Excel Worksheet Functions	2	January 21st 05 05:26 PM

All times are GMT +1. The time now is 09:57 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us