(Msg. 1) Posted: Wed Aug 20, 2008 9:13 am
Post subject: multifunction formula Archived from groups: microsoft>public>excel>worksheet>functions (more info?)
I am trying to do a formula that would give me a count for multiple factors
A B
Loacation name Event type
looking for a count if location= specific name and Event type=specific
This is what I have, but is not working. What am I missing. Help....
(Msg. 2) Posted: Wed Aug 20, 2008 12:25 pm
Post subject: Re: multifunction formula [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
"Bobbie" <Bobbie.DeleteThis@discussions.microsoft.com> wrote in message
news:D31FB44B-29A5-41CC-A18A-7E0A046E9D7F@microsoft.com...
>I am trying to do a formula that would give me a count for multiple factors
> A B
> Loacation name Event type
>
> looking for a count if location= specific name and Event type=specific
> This is what I have, but is not working. What am I missing. Help....
>
> =COUNT(IF('2008 Events'!C2:C220=Sheet2!A7,IF('2008
> Events'!F2:F220=Sheet2!C1,0),0))
> --
> Thanks, Bobbie
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