Retrieving a value next to a specific cell

Copper Contributor

I was wondering what formula I need to be able to retrieve all of the values next to specific categories and sum them.

For example, get all of the values next to each food cell in the above range, sum them, and place them under total in the lower table.

Screenshot 2022-01-14 115721.png

2 Replies

@lopezn6 

Why not use PivotTable?

@lopezn6 

Actually, as Mr. Baklan said, the best solution is pivot.

But if there is no possibility for pivot, then here is a simple COUNTIFS function for doing your self :).

Example in the file, maybe it helps...if not, please just ignore :).