Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 1,814

SUMIF, IF ?

I have this formula:
=SUMIF($B116:$B124,"V",S116:S124)

In Q116:Q124, I have various numbers, such as 1300, 1400, 1500.

What can I add to the above formula to get the result for only the rows that
have 1300 in the Q116:Q124 range.

Thanks,

Steve

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	Sulasno[_2_]	New Users to Excel	8	December 11th 07 08:48 PM
sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A"	Harry Seymour	Excel Worksheet Functions	9	June 12th 07 10:47 PM
Embedding a Sumif in a sumif	C.Pflugrath	Excel Worksheet Functions	5	August 31st 05 07:31 PM
nested sumif or sumif with two criteria	dshigley	Excel Worksheet Functions	5	April 5th 05 03:34 AM
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function	Oscar	Excel Worksheet Functions	2	January 11th 05 11:01 PM

All times are GMT +1. The time now is 07:56 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us