Previous Topic Next Topic

If... Then

Closed
chrisdantonelli Posts 1 Registration date Wednesday July 2, 2014 Status Member Last seen July 2, 2014 - Jul 2, 2014 at 01:54 PM
Osama_bb11 Posts 21 Registration date Sunday May 25, 2014 Status Member Last seen September 25, 2014 - Jul 5, 2014 at 12:48 AM
Greetings all, I hope I can explain this correctly as this is my first time asking questions on a public forum.

All me to set the stage.

A = Person name
B = Cost per ticket/priority of seating (I've conditionally formatted it to turn red for 1000, yellow for 500 and green for 100)
C = Number of tickets

What I'm looking to do is make a chart that in

G = Red Seats sold
H = Yellow Seats Sold
I = Green Seats Sold

How do I make it say
"If C = 8 and B is red then G = 8"
"If C2 is 24, and B2 is yellow then H = 24"
If C3 is 16 and B3 is green then I = 16"

Any help would be appreciated. Thanks all.

2 responses

Answer 1 / 2
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Jul 2, 2014 at 04:59 PM
crisdantonelli, Good evening.

Your explanation sounds a little confuse.

Save your file at a free site, www.speedyshare.com and put the download link here.

Remenber to fill data enough to show what you want and put manually the desired results.
Answer 2 / 2
Osama_bb11 Posts 21 Registration date Sunday May 25, 2014 Status Member Last seen September 25, 2014
Jul 5, 2014 at 12:48 AM
Hi

( ticket prices at range B2:B100 )
(number of tickets at range C2:C100)

then but at G2=sumif(B2:B100,1000,C2:C100) to find how many ticket "1000"
but at H2=sumif(B2:B100,500,C2:C100) to find how many ticket "500"
but at I2 =sumif(B2:B100,100,C2:C100) to find how many ticket "100"

I Hope this will meet you requirements