CampbellSoup
New Member
- Joined
- Apr 27, 2019
- Messages
- 9
Im looking to add the numbers from columns EL-EP based on criteria from column F. I'm trying to get a formula that will check column F for say "CC" and look through the criteria between EL5564-EP5568 and only calculate those figures in the line for "CC". hope I'm explaining it right.
I basically want to add up sales persons numbers and have the values in the graph below. But the numbers will span multiple columns and rows that are larger than the criteria established. I tried this formula here and its no good...Surely excel has a way to do this easily.
I basically want to add up sales persons numbers and have the values in the graph below. But the numbers will span multiple columns and rows that are larger than the criteria established. I tried this formula here and its no good...Surely excel has a way to do this easily.
Excel Formula:
=SUMIF(F5564:F5568,"CC",EL5564-EP5568)