Posted to microsoft.public.excel.worksheet.functions

ottodesque ottodesque is offline

external usenet poster

Posts: 9

Need Countifs Formula Help

I have created the formula =COUNTIFS('FEB
FY10'!$P$7:$P$126,"Australia",$BG$7:$BG$126,"= 100")/C19. The problem is
that cells BG7:BG126 contain a formula so the formula returns a value of 0 as
it does not see the results of the formula in BG7:BG126. How can I make this
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
CountIfs	vreeckes	Excel Worksheet Functions	4	February 19th 09 02:57 AM
COUNTIFS with an OR?	RobofMN	Excel Worksheet Functions	3	January 20th 09 01:58 AM
Countifs to Sumproduct for 2003 - was Simple Countifs.. from Fr	Steve	Excel Worksheet Functions	2	January 4th 09 05:36 PM
"countifs" convert to formula in XL2002	Alan	Excel Worksheet Functions	2	February 11th 08 10:01 AM
COUNTIFS Formula Problem	Jim	Excel Worksheet Functions	6	November 20th 07 04:39 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us