Posted to microsoft.public.excel.programming

Graham[_2_] Graham[_2_] is offline

external usenet poster

Posts: 32

SUMIFS in Programming

Below is waht ideally I would like to do with a procedure and I know
this will not work with n in a formula, it was just to show the concept
of what I was after.
I would appreciate any guidance.

Graham

For n = 37 To 44

Cells(3, n).Select

ActiveCell.FormulaR1C1 = _

"=SUMIFS(R15C14:R600C14,R15C13:R600C13,R2Cn,R15C4: R600C4,R3C35)"

Next n

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	MyLan	Excel Discussion (Misc queries)	2	April 6th 10 08:34 PM
Sumifs (I think)	Jeff	Excel Worksheet Functions	5	November 19th 09 06:15 PM
Sumifs & Not Like	Cow Girl	Excel Discussion (Misc queries)	6	March 13th 09 08:34 PM
SUMIFS	Mark	Excel Discussion (Misc queries)	3	November 28th 07 12:09 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us