| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
sumif function
is it possible to use 2 criterias?
tia |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
sumif function
Have a look at JW's site
http://www.j-walk.com/ss/excel/tips/tip74.htm Mike "Sulasno" wrote: is it possible to use 2 criterias? tia |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
sumif function
It depends on what you are doing.
=SUMIF(D1:D11,"5")-SUMIF(D1:D11,"10") will sum all numbers from 5 to 10 in the range =SUMPRODUCT((B1:B11="Sandy")*(C1:C11="Sulasno")*D1 :D11) will sum every entry in D1:D11 where there is an entry in Column B of "Sandy" and an enrty of "Sulasno" in Column C -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Sulasno" wrote in message ... is it possible to use 2 criterias? tia |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
sumif function
For details on SUMPRODUCT see
http://www.xldynamic.com/source/xld.SUMPRODUCT.html http://mcgimpsey.com/excel/formulae/doubleneg.html -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Sulasno" wrote in message ... is it possible to use 2 criterias? tia |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
sumif function
thanks to everyone for the links
"Sulasno" wrote in message ... is it possible to use 2 criterias? tia |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to nest a left function within a sumif function? | Excel Worksheet Functions | |||
| How do I use the TODAY function with the SUMIF function? | Excel Worksheet Functions | |||
| SUMIF Function Inside SUMPRODUCT Function | Excel Worksheet Functions | |||
| Can SUMIF function include AND function | Excel Worksheet Functions | |||
| SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions | |||
![Sulasno[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
