sumif with multiple conditions

Domenic

Posts: n/a

Is this what you mean?

=SUMPRODUCT(--(A1:A100="week1"),--(B1:B100=""))

In article ,
"Ray" wrote:

KL,

Thanks for your useful suggestion. Is it possible to apply to countif
function as well?

Thanks,

Ray

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 - multiple conditions	J_Barn	Excel Worksheet Functions	4	June 28th 05 11:55 PM
Conditional Sum and multiple conditions across different sheets	Michael Dreher	Excel Worksheet Functions	1	May 26th 05 05:25 PM
SUM based on multiple conditions - SORRY, URGENT!!!	marika1981	Excel Worksheet Functions	4	February 18th 05 11:13 AM
How to multiple conditions to validate more than 2 conditions to .	Bhuvana Govind	Excel Worksheet Functions	1	January 28th 05 07:07 PM
Sum(if ... multiple conditions ... Interpretation?	Ken	Excel Discussion (Misc queries)	6	December 16th 04 10:23 PM

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

Menu

About Us