Excel Totaling Numbers in Columns

April 6, 2009 at 10:02:22
Specs: Windows XP, 1.0 Gb
I have an Excel spreadsheet that has 40 rows and several columns which includes "Legend", "HRS", and "$" as column headers and there are eight categories to select from a drop down menu in "Legend".

As an example, I need to identify all individual "Legend" categories, i.e., VAC, which could be in one or more than one row, not necessarily in consecutive order, and then total the corresponding "HRS" and "$" for VAC.

I have tried IF/AND but was not able to get it correct.

Thank you.

See More: Excel Totaling Numbers in Columns

Report •

April 6, 2009 at 11:53:38
Did you try SUMIF()?

Let's say Legends has data in A2:A40 and Hrs is B2:B40.

This would sum all values in the same rows in B2:B40 where A2:A40 contains VAC:


Report •

April 7, 2009 at 05:42:54

Thank you for your response. =SUMIF worked as needed.

Brian W

Report •

Related Solutions

Ask Question