Posted to microsoft.public.excel.programming

Jim[_73_]

external usenet poster

Posts: 24

SUMIF and SUMIFS Error

It seems that I have to concatenate the criteria arguments in the
SUMIF and SUMIFS functions since I have moved to Excel 2007. For
example, "D$4" must become ""&D$4 in the Excel 2007 version. Is this
a change in syntax or a bug that needs to be addressed. Any
thoughts...

Jim

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
SUMIF or SUMIFS help	RLD	Excel Worksheet Functions	1	March 12th 10 12:11 AM
SumIf or SumIfs or something else?	crmccurry	Excel Worksheet Functions	2	April 18th 09 05:46 PM
sumifs, sumif with dates	Richard Manor	Excel Worksheet Functions	6	November 13th 08 12:19 AM
SUMIF and SUMIFS	Colts41	Excel Worksheet Functions	0	August 27th 08 06:11 PM
SUMIF or SUMIFS	Jeff[_10_]	Excel Worksheet Functions	4	January 30th 08 07:11 AM

All times are GMT +1. The time now is 07:29 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us