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.

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:

=SUMIF(A2:A40,"VAC",B2:B40)

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

Brian W

Ask Your Question

Weekly Poll

Would you ride in a self-driving car from Tesla?

Discuss in The Lounge

Poll History