Posted to microsoft.public.excel.misc

Jonas

Posts: n/a

=SUMIF(A2:A34,"=F37",E2:E34) Why doesn't this formula work

Ranges A2:A34 contain dates. A date entered into F37 is intended to return
the sums that match from E2:E34. Why do I only return zero?

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
Why does this Formula work?	Kevin Vaughn	Excel Worksheet Functions	3	April 7th 06 09:21 PM
Making this formula work	Kleev	Excel Worksheet Functions	5	December 15th 05 12:42 AM
Formula do not work until edited	KiwiSteve	Excel Discussion (Misc queries)	12	November 8th 05 09:45 AM
IF / VLOOKUP formula won't work until saved	tawtrey(remove this )@pacificfoods.com	Excel Worksheet Functions	2	August 4th 05 11:55 PM
Formula checking multiple worksheets	sonic-the-mouse	Excel Worksheet Functions	2	June 5th 05 07:48 PM

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

About Us

"It's about Microsoft Excel"