ExcelBanter - Adding numbers based on Range

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Adding numbers based on Range (https://www.excelbanter.com/excel-worksheet-functions/234302-adding-numbers-based-range.html)

Carla

Adding numbers based on Range

In the C column I have categories and in the J column I have Hours

Is there a formula to where I can look up the category "Library" in C and
add only those numbers in column J?

Gary''s Student

Adding numbers based on Range

=SUMPRODUCT(--(C1:C10="Library"),(J1:J10))

--
Gary''s Student - gsnu200857

Shane Devenshire[_2_]

Adding numbers based on Range

Hi,

SUMIF($C$1:$C$100,"Library",$J$1:$J$100)
or enter Library in A1 and use
SUMIF($C$1:$C$100,A1,$J$1:$J$100)

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire

"Carla" wrote:

In the C column I have categories and in the J column I have Hours

Is there a formula to where I can look up the category "Library" in C and
add only those numbers in column J?

All times are GMT +1. The time now is 01:36 AM.