Posted to microsoft.public.excel.worksheet.functions

PFAA

external usenet poster

Posts: 9

SUM+IF Array formula

I'm using a {=SUM(IF((A2:A11="1188")*(B2:B11="Feb"),C2:C11))}

I need to count the # in Column C when the criteria is met in A and B. This
is an array formula.

And I keep getting 0....

What am I doing wrong?

Thanks,

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
meaning of : IF(Switch; Average(array A, array B); array A)	DXAT	Excel Worksheet Functions	1	October 24th 06 06:11 PM
Array Formula	Brendan Vassallo	Excel Discussion (Misc queries)	4	September 13th 06 02:25 AM
Array formula	Marcelo	Excel Worksheet Functions	3	May 24th 06 09:05 PM
(array?) formula	Jack Sons	Excel Discussion (Misc queries)	2	December 29th 05 09:24 PM
Array Formula - using LEFT("text",4) in formula	Andrew L via OfficeKB.com	Excel Worksheet Functions	2	August 1st 05 02:36 PM

All times are GMT +1. The time now is 06:36 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us