I have a column of numbers and two columns with conditions. How do I sum the numbers that = a value in each of the columns of conditions.
Thanks
File attached
I have a column of numbers and two columns with conditions. How do I sum the numbers that = a value in each of the columns of conditions.
Thanks
File attached
Hi
First one
=SUMIFS(E5:E24,C5:C24,100,D5:D24,"Red")
HTH
rylo
Perfect, thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks