Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumif and numberif
-- Just a regular user |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumif and numberif
What is the question.
-- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Rockbear" wrote in message ... -- Just a regular user |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumif and numberif
Hi
I have two sum function that work as they should, but try to set another agrument and then it fails.. First one : =ANTALL.HVIS(E:E,N2), in english i thin it is COUNTIF(E:E,N2) I am trying ti get it to say COUNTIF(E:E,N2 AND K:K<100) IF the E:E finds the value of N2, and the number in K:K is less than 100 it should count all under 100. The same with 101 t0 300 NUMBER.IF(E:E,N2 AND K:K100 and 300) Second sum the numbers : =SUMIF((E:E,N2,K:K) =SUMIF((E:E,N2 AND K:K<100) Sum all numbers from 0 to 100 in K:K if N2 are found in E:E =SUMIF(E:E,NR AND K:K100 and 300) SUM all numbers between 101 and 300 if N2 are found in E:E -- Just a regular user "Ashish Mathur" wrote: What is the question. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Rockbear" wrote in message ... -- Just a regular user |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumif | Excel Discussion (Misc queries) | |||
sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A" | Excel Worksheet Functions | |||
Embedding a Sumif in a sumif | Excel Worksheet Functions | |||
nested sumif or sumif with two criteria | Excel Worksheet Functions | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions |