Posted to microsoft.public.excel.misc

Eric D

external usenet poster

Posts: 50

SUMIF statement with AND statement

thanks pete, this works great
--
Eric

"Eric D" wrote:

Can anyone tell me how to use a SUMIF statement with a AND statement?

I need it to sum e3 when d3="in repay" except for when c3="consolidation"
--
Eric

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 statement	Karen Smith	Excel Discussion (Misc queries)	4	October 20th 06 06:39 PM
Sumif statement	knbsmith11	Excel Discussion (Misc queries)	4	April 6th 06 06:01 PM
sumif statement	Jackie	Excel Discussion (Misc queries)	7	March 9th 06 04:40 PM
Help please, IF statement/SUMIF statement	Brad_A	Excel Worksheet Functions	23	January 11th 05 02:24 PM
sumif statement	Ted Metro	Excel Worksheet Functions	1	January 7th 05 04:18 PM

All times are GMT +1. The time now is 04:24 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us