(Msg. 1) Posted: Wed Aug 20, 2008 11:38 am
Post subject: SUMIFS with 3 criteria instead of just 2 Archived from groups: microsoft>public>excel>worksheet>functions (more info?)
I am trying to get SUMIFS function to SUM a range of cells only if three
criteria are met. I have tried the SUMIFS function for two of the criteria
and then added SUMIF to the end for the 3rd criteria, but it always defaults
to the SUMIF function even though the first 2 criteria are not met.
(Msg. 2) Posted: Wed Aug 20, 2008 11:59 am
Post subject: Re: SUMIFS with 3 criteria instead of just 2 [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
"Hopper" <Hopper.TakeThisOut@discussions.microsoft.com> wrote in message
news:DE38A9E8-73AC-4B99-99F3-36187FA6AC50@microsoft.com...
>I am trying to get SUMIFS function to SUM a range of cells only if three
> criteria are met. I have tried the SUMIFS function for two of the
> criteria
> and then added SUMIF to the end for the 3rd criteria, but it always
> defaults
> to the SUMIF function even though the first 2 criteria are not met.
>
> Example:
>
> =SUMIFS(C32:C33,E32:E33,"4",G32:G33,"6")+SUMIF(I32:I33,"<96",C32:C33)
>
> It is adding cells together even when 4 & 6 criteria are not met.
>
> Anyone have any ideas!
>
> Thank you!
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office