Posted to microsoft.public.excel.misc

Jeanette

external usenet poster

Posts: 24

two if conditions, then a counta formula issue

I need the formula which will do the following: If sheet1A3:A1000=70 and if
sheet1B3:B1000="OCT, then COUNTA(sheet1C3:C1000), it worked once and can't
get it to work again.

=IF('sheet1'!$A$3:$A200=70,IF('sheet1'!$B$3:$B200= "OCT",COUNTA('sheet1'!C3:C200),""))

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
Help with COUNTA formula	Randy	Excel Discussion (Misc queries)	2	February 11th 10 11:34 PM
Formula for Counta	Newfie809	Excel Worksheet Functions	5	May 26th 09 02:01 PM
Counta formula	lla	Excel Discussion (Misc queries)	1	May 11th 06 12:23 AM
help me on tough sum on conditions issue	amrezzat	Excel Worksheet Functions	4	November 15th 05 10:06 AM
COUNTA Function not working =COUNTA(C3:C69,"NH")	MikeinNH	Excel Worksheet Functions	2	November 8th 04 01:19 AM

All times are GMT +1. The time now is 08:27 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us