WUGNET, the Windows User Group Network
Your Complete Resource Center for "The Best" in Shareware, Computing Tips and Support, Windows Industry News... and much more!
Home Forums Shareware Windows Tips Hot Offers FREE Newsletters Arcade Contact Us About Partners
Search WUGNET: RSS Feeds RSS Feeds Advertise with WUGNET    |    Shareware eBooks
HomeHome FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

CountIF() & SumIF() with multiple criteria

  
   Home -> Office -> Worksheet Functions RSS
Next:  Data Entry with forms  
Author Message
NoodNutt

External


Since: Feb 23, 2008
Posts: 126



(Msg. 1) Posted: Thu Sep 04, 2008 3:03 am
Post subject: CountIF() & SumIF() with multiple criteria
Archived from groups: microsoft>public>excel>worksheet>functions (more info?)
G'day everyone

Need a little help with the following please.

Using 97-2003 format

=COUNTIF(AND('2008'!$B5:$B2004,"Eastern Creek",'2008'!$E5:$E2004,"VIC"))

Essential what I am need is to count only the records that match column B &
D.

=SUMIF(AND('2008'!$B5:$B2004,"Eastern
Creek",'2008'!$E5:$E2004,"VIC"),'2008'!$I5:$I2004))

Again match the 2 criteria, sum only that which matches in Column (i).

TIA
Mark.
Back to top
Login to vote
T. Valko

External


Since: Nov 24, 2006
Posts: 9072



(Msg. 2) Posted: Thu Sep 04, 2008 3:03 am
Post subject: Re: CountIF() & SumIF() with multiple criteria [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Try these:

=SUMPRODUCT(--('2008'!$B5:$B2004="Eastern
Creek").--('2008'!$E5:$E2004="VIC"))

=SUMPRODUCT(--('2008'!$B5:$B2004="Eastern
Creek"),--('2008'!$E5:$E2004="VIC"),'2008'!$I5:$I2004)

--
Biff
Microsoft Excel MVP


"NoodNutt" <mclind1.RemoveThis@bigpond.com> wrote in message
news:etHhnIjDJHA.3432@TK2MSFTNGP05.phx.gbl...
> G'day everyone
>
> Need a little help with the following please.
>
> Using 97-2003 format
>
> =COUNTIF(AND('2008'!$B5:$B2004,"Eastern Creek",'2008'!$E5:$E2004,"VIC"))
>
> Essential what I am need is to count only the records that match column B
> & D.
>
> =SUMIF(AND('2008'!$B5:$B2004,"Eastern
> Creek",'2008'!$E5:$E2004,"VIC"),'2008'!$I5:$I2004))
>
> Again match the 2 criteria, sum only that which matches in Column (i).
>
> TIA
> Mark.
>
Back to top
Login to vote
NoodNutt

External


Since: Feb 23, 2008
Posts: 126



(Msg. 3) Posted: Fri Sep 05, 2008 3:03 am
Post subject: Re: CountIF() & SumIF() with multiple criteria [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
G'day Biff

Thx you so much, you've saved me again

Regards
Mark.
Back to top
Login to vote
T. Valko

External


Since: Nov 24, 2006
Posts: 9072



(Msg. 4) Posted: Fri Sep 05, 2008 3:03 am
Post subject: Re: CountIF() & SumIF() with multiple criteria [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"NoodNutt" <mclind1 DeleteThis @bigpond.com> wrote in message
news:uqFfrwvDJHA.3352@TK2MSFTNGP05.phx.gbl...
> G'day Biff
>
> Thx you so much, you've saved me again
>
> Regards
> Mark.
>
>
>
Back to top
Login to vote
Sharyn

External


Since: Sep 11, 2008
Posts: 1



(Msg. 5) Posted: Thu Sep 11, 2008 6:34 am
Post subject: Re: CountIF() & SumIF() with multiple criteria [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Thank you, Thank you, Thank you!!!!
--
Sharyn


"T. Valko" wrote:

> You're welcome. Thanks for the feedback!
>
> --
> Biff
> Microsoft Excel MVP
>
>
> "NoodNutt" <mclind1 RemoveThis @bigpond.com> wrote in message
> news:uqFfrwvDJHA.3352@TK2MSFTNGP05.phx.gbl...
> > G'day Biff
> >
> > Thx you so much, you've saved me again
> >
> > Regards
> > Mark.
> >
> >
> >
>
>
>
Back to top
Login to vote
T. Valko

External


Since: Nov 24, 2006
Posts: 9072



(Msg. 6) Posted: Thu Sep 11, 2008 12:31 pm
Post subject: Re: CountIF() & SumIF() with multiple criteria [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
You're quite welcome!

--
Biff
Microsoft Excel MVP


"Sharyn" <Sharyn RemoveThis @discussions.microsoft.com> wrote in message
news:66E5151F-5FD7-4C9C-81B3-5246A02ECA10@microsoft.com...
> Thank you, Thank you, Thank you!!!!
> --
> Sharyn
>
>
> "T. Valko" wrote:
>
>> You're welcome. Thanks for the feedback!
>>
>> --
>> Biff
>> Microsoft Excel MVP
>>
>>
>> "NoodNutt" <mclind1 RemoveThis @bigpond.com> wrote in message
>> news:uqFfrwvDJHA.3352@TK2MSFTNGP05.phx.gbl...
>> > G'day Biff
>> >
>> > Thx you so much, you've saved me again
>> >
>> > Regards
>> > Mark.
>> >
>> >
>> >
>>
>>
>>
Back to top
Login to vote
Display posts from previous:   
       Home -> Office -> Worksheet Functions 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
Categories:
 Windows XP
 Windows Vista
 Windows Other
  Office
 Office Other
 Security
 WinRAR
  • Home |
  • Shareware |
  • Windows Tips |
  • Hot Offers |
  • FREE Newsletters |
  • Arcade |
  • Forums |
  • eBooks |
  • About WUGNET |
  • Partners |
  • Contact

  • WUGNET Privacy Policy |
  • Link to WUGNET