Dominique Feteau

Posts: n/a

Sumproduct #num error

I always have trouble setting up sumproduct functions.

I have a sheet called "diary". In column I, i have diary codes (505, 510,
ect.). In column C, i have number codes that break down each diary code
(1-8). I want to count how many of each number code, i have for each diary
code. I'm using this function, but it returns an error. What am i doing
wrong?

=SUMPRODUCT((diary!I:I="510")+(diary!C:C="6"))

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
Findlink Error	D Moniz via OfficeKB.com	Links and Linking in Excel	0	January 20th 05 04:53 PM
Error when entering and exiting excel	Randy	Excel Discussion (Misc queries)	1	January 11th 05 03:17 PM
Sumproduct function not working	Scott Summerlin	Excel Worksheet Functions	12	December 4th 04 05:15 AM
adding two sumproduct formulas together	ski2004_2005	Excel Worksheet Functions	1	November 12th 04 09:08 PM
#REF error	Christen	Excel Worksheet Functions	5	November 3rd 04 07:29 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us