How do I set up a countif, or sumif that is multiconditional?
You are welcome Mr Yanni
"Mr. Yanni" escreveu:
"Marcelo" wrote:
Hy Yanni
try to use
=sumproduct(--($a$2:$a$100="radio")*($B$2:$b$100=date)*($c$2:$c$ 100))
assuming that the revenue are on the C column
hope this helps
regards from Brazil
Marcelo
"Mr. Yanni" escreveu:
I often try to set up a countif or a sum if that is conditional on two or
more conditions. For instance - I have Radio stations listed in one column,
flight dates in another column, number of contacts for each flight in another
column and appointments created from those contacts and finally, revenue
generated form those appointments. One example would be to sumif column one
equals the radio station and column two equaled the flight date then give me
the revenue.
I did not know such a function existed. I will give it a try. Thank you my
brazilian friend. gracious.
|