Posted to microsoft.public.excel.misc

external usenet poster

Posts: 6

SUMIFS

My SUMIFS formula was "accepted" but the result is 0.0 even though there are
numbers to add. What can the problem be?
The formula is =SUMIFS(AN3:AN997,C3:C997,"ARC",D3:D997,"EOC")
I want the total form column AN when column C is ARC and when column D is EOC

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
How do I use sumifs -	wantfit	Excel Worksheet Functions	1	April 22nd 10 09:37 PM
SUMIFS help	Peter	Excel Worksheet Functions	3	March 4th 10 11:27 PM
SUMIFS	MurrayBarn	Excel Worksheet Functions	4	June 15th 09 08:02 AM
SUMIFS	Mark	Excel Discussion (Misc queries)	3	November 28th 07 12:09 PM
SUMIFS and OR	M.S. Westerbeek	Excel Worksheet Functions	6	August 23rd 07 07:24 PM

All times are GMT +1. The time now is 01:00 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us