Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
funtion SUMAR.SI
how I can make a multiple condition in function SUMAR.SI?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
funtion SUMAR.SI
Hi,
I think you are talking about SUMIF. you can use Sumproduct (maybe SUMARPRODUCTO in spanish), =sumproduct(--(a2:a1000="1st conditional")*(b2:b1000="2nd conditional");(c2:c1000)) it'll return the sum of the data on the C column if the data on columns A and B match with the conditionals. hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "xavi" escreveu: how I can make a multiple condition in function SUMAR.SI? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
indirect funtion | Excel Discussion (Misc queries) | |||
If Funtion | Excel Worksheet Functions | |||
search funtion | Excel Worksheet Functions | |||
If funtion help | New Users to Excel | |||
IF funtion | Excel Discussion (Misc queries) |