Multiple Countif and sumif statements

September 12, 2010 at 21:52:40
Specs: Windows Vista
We have 3 columns

Column A Column B Column C

12 Apple Good
23 Apple Bad
45 Apple worst

we had made a shhet which is consolidated. We have applied validation in every column so that we can selet different fruits.

Now in consolidated sheet we whould get


No of apples No of good apples No of apples No . of good apples
Apples
Mangoes


See More: Multiple Countif and sumif statements

Report •


#1
September 13, 2010 at 05:47:07
Are you just telling us what you have or are you asking us a question?

Report •

#2
September 13, 2010 at 10:45:16
I am having this and I am asking a slotion for this

Report •

#3
September 13, 2010 at 11:31:51
Hi,

Is this a course project.


Regards


Report •

Related Solutions

#4
September 13, 2010 at 11:44:09
You said that you want this:

No of apples No of good apples No of apples No . of good apples 
Apples 
Mangoes"

You appear to be asking for 2 sets of the same pairs of data:

No of apples
No of good apples
No of apples
No . of good apples

Is that really what you want?

Can I assume that this is actually what you want:

    A         B       C      D
1  Fruit     Good    Bad    Worst
2  Apples     12      23     45
3  Mangos      x       y      z

Please confirm.

In addition, please tell us what version of Excel you are using.


Report •

#5
September 13, 2010 at 20:31:18
We are using Excel 2003

Report •

#6
September 13, 2010 at 20:53:00
And i also want to know how to use COUNT on a column with Text in it rather than numbers.. We have tried COUNTA also but it was also not working

Report •


Ask Question