Previous Topic Next Topic

If... Then

Closed
chrisdantonelli Posts 1 Registration date Wednesday 2 July 2014 Status Member Last seen 2 July 2014 - 2 Jul 2014 à 13:54
Osama_bb11 Posts 21 Registration date Sunday 25 May 2014 Status Member Last seen 25 September 2014 - 5 Jul 2014 à 00:48
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

Réponse 1 / 2
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 147
2 Jul 2014 à 16:59
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.
Réponse 2 / 2
Osama_bb11 Posts 21 Registration date Sunday 25 May 2014 Status Member Last seen 25 September 2014
5 Jul 2014 à 00:48
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