Posted to microsoft.public.excel.worksheet.functions

Katie

external usenet poster

Posts: 130

SumIf and ranges

hr 5 10
hr 2 8
act 6 9
hr 3 6

Want to sum this range of numbers if the office department is "act".
=IF((A1:A4),"act",SUMPRODUCT(B1:C4)) does not work,
nor the sumif.......
there has to be a creative solution!
katie

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 with 2 ranges & 2 criteria	cgibby	Excel Worksheet Functions	6	January 4th 08 08:58 PM
SUMIF ranges	John	Excel Worksheet Functions	2	September 24th 07 03:54 PM
SUMIF using two ranges	yvonneb	Excel Discussion (Misc queries)	3	May 31st 07 12:46 PM
SumIF Multiple Ranges	Erika	Excel Worksheet Functions	2	April 28th 05 05:40 PM
SUMIF and 3-D Ranges	Ron In Tulsa	Excel Worksheet Functions	2	November 22nd 04 07:30 PM

All times are GMT +1. The time now is 03:10 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us