Posted to microsoft.public.excel.misc

Ronda

external usenet poster

Posts: 17

SumIf Question

I have a spreadsheet that I need to do a calculation if the answer is yes or
"Y". I put the formula below in and it works correctly for the "N" formula.
If the answer is "Y" the formula does not give me the sum of F1+G1 (actually
"-" but I put the number in as a negative) but the total of F1 instead.

=SUMIF(H1,"Y",F1:G1)+SUMIF(H1,"N",F1)

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
Help Please SUMIF question	baz	Excel Discussion (Misc queries)	1	February 14th 08 11:39 PM
SUMIF question	Billy B	Excel Worksheet Functions	4	January 30th 08 10:44 PM
SUMIF Question	Owen888	Excel Worksheet Functions	4	September 28th 06 07:14 PM
SUMIF Question	Barb Reinhardt	Excel Worksheet Functions	11	May 3rd 06 12:37 AM
Sumif question	J Shrimps, Jr.	Excel Worksheet Functions	5	January 20th 06 05:26 PM

All times are GMT +1. The time now is 05:52 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us