ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   sumif function (https://www.excelbanter.com/excel-worksheet-functions/189360-sumif-function.html)

Shi Gharib

sumif function
 
Hi
in a table I have several columns that contains in the first row a part of
the same name ex: "BRV"
I want to sum several separated rows that have the same above condition.
is there a way in the sumif function or is there a way to use the sumproduct
function that allows me to have one condition and multiple values to
calculate

--
Shi Gharib

Aladin Akyurek

sumif function
 
Care to provide a small sample along with the expected outcome?

Shi Gharib wrote:
Hi
in a table I have several columns that contains in the first row a part of
the same name ex: "BRV"
I want to sum several separated rows that have the same above condition.
is there a way in the sumif function or is there a way to use the sumproduct
function that allows me to have one condition and multiple values to
calculate



All times are GMT +1. The time now is 05:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com