Posted to microsoft.public.excel.worksheet.functions

vacation

Posts: n/a

sumproduct returns zero

The following formula gives me a zero result :
=SUMPRODUCT((B2:B18="joe")*(F2:F18"0"))

I want to count all occurences of values$0.00 in Column F only if column
B=Joe in a filtered list.

Thank you

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
pleas help: sumproduct function returns #value or #ref error	Jennie	Excel Worksheet Functions	1	June 24th 05 04:51 PM
sumproduct function returns #value or #ref error	Jennie	Excel Worksheet Functions	4	June 24th 05 04:19 PM
returns calculation using sumproduct	Stan Altshuller	Excel Worksheet Functions	6	January 13th 05 12:25 AM
Sumproduct function not working	Scott Summerlin	Excel Worksheet Functions	12	December 4th 04 05:15 AM
GET.CELL	Biff	Excel Worksheet Functions	2	November 24th 04 07:16 PM

All times are GMT +1. The time now is 03:21 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us