The attached work book shows columns of numbers which can be either from "a" or "b". I use a SUMIF formula for each column to add the figures for "a" and then sum these to get the total number for the whole table
It occurs to me that by using a formula like SUMIF($E:$E,"a",$F:$L) I could do this in one go. Unfortunately this formula does not work, so I would be very grateful for one that does.
John
Bookmarks