Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
scenario:
i would like to return two numbers, the count of times each fruit occurs when <5 and =5, and the sum of the value when each fruit is <5 and =5 FRUIT $$$ apple 1 orange 2 pear 1 pear 8 pear 5 apple 6 should return apple orange pear sum <5 1 2 1 sum =5 6 0 13 apple orange pear count <5 1 1 1 count =5 1 0 2 how do i go about this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Count number of times a text occurs | New Users to Excel | |||
Need to Count the number of times a value occurs within a dt range | Excel Worksheet Functions | |||
Count the number of times a name occurs in a column | Excel Worksheet Functions | |||
How to count the number of times something occurs within a certain month | Excel Worksheet Functions | |||
How do I count the times a number occurs in a given criteria? | Excel Discussion (Misc queries) |