Posted to microsoft.public.excel.programming

external usenet poster

Posts: 246

Sumif problem

I have a table where I want to sum all the values in "F", if the cells
in "A" begin with "05". "A" actually contains account numbers, which
are text, that the first two numbers are the fiscal year. I can't quite
get my head around a sumif or other formula. TIA

Greg

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 problem	richierich1961	Excel Worksheet Functions	5	September 28th 07 02:09 PM
Sumif problem	Gerry Cornell	Excel Worksheet Functions	6	January 9th 07 03:04 PM
SumIf Problem	Brian Matlack	Excel Discussion (Misc queries)	7	April 18th 06 12:26 AM
SUMIF problem	Hodge	Excel Worksheet Functions	1	November 11th 04 11:48 AM
SUMIF problem	Hodge	Excel Worksheet Functions	1	November 11th 04 11:02 AM

All times are GMT +1. The time now is 12:20 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us