Gurus,
I need to average a column say B:B (with dollars) only if Column A:A contains either A or B or E. Any help will be highly appreciate.
Regards,
Xenos
Hi
I am not a Guru..but you can try, something like this.
=IF(COUNTIF(A:A;"A")+COUNTIF(A:A;"B")+COUNTIF(A:A;"C")>0;AVERAGE(B:B);"")
Hope to helps you
Regards
Fotis.
I am proud that i am Greek.
Just to know every one.We Greeks, we are nοt proud of our politicians. Υou?
Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
My Avadar picture, is from Athens Acropolis.
http://www.theacropolismuseum.gr
http://www.visitgreece.gr/
This regular formula averages the Col_B cells where the corresponding Col_A cell equals any of a, b, or e
Is that something you can work with?C1: =SUM(SUMIF(A:A,"="&{"a","b","e"},B:B))/SUM(COUNTIF(A:A,"="&{"a","b","e"}))
Thanks for the prompt reply but after using your formula the answer is not coming correct.
Thanks for the prompt reply but after using your formula the answer is not coming correct
Thanks Ron,Originally Posted by Ron Coderre
How to use same example for countif?
..An example is here..
Regards
Fotis.
I am proud that i am Greek.
Just to know every one.We Greeks, we are nοt proud of our politicians. Υou?
Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
My Avadar picture, is from Athens Acropolis.
http://www.theacropolismuseum.gr
http://www.visitgreece.gr/
In this part of the formula I posted:
SUM(COUNTIF(A:A,"="&{"a","b","e"}))
This section: "="&{"a","b","e"}
resolves to these three distinct criteria:
="a"
="b"
="e"
(The braces {} define the beginning and end of the array of values)
Consequently, this: SUM(COUNTIF(A:A,"="&{"a","b","e"}))
is equivalent to this:
SUM(COUNTIF(A:A,="a"),COUNTIF(A:A,="b"),COUNTIF(A:A,="e"))
I hope that helps
Thanks RonConsequently, this: SUM(COUNTIF(A:A,"="&{"a","b","e"}))
is equivalent to this:
SUM(COUNTIF(A:A,="a"),COUNTIF(A:A,="b"),COUNTIF(A:A,="e"))
First time see this...
I dIdn't knew this!
Regards
Fotis.
I am proud that i am Greek.
Just to know every one.We Greeks, we are nοt proud of our politicians. Υou?
Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
My Avadar picture, is from Athens Acropolis.
http://www.theacropolismuseum.gr
http://www.visitgreece.gr/
Can this be done while excluding cells that are blank?
Also can the conditions "a", "b", "e" be a reference to another cell?
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks