Hi,
I am using the following =SUMIFS($Z4:$JY4,$Z$3:$JY$3,"Normal",$Z$1:$JY$1,"="&$B$2)
Which works fine for one row, how can I adapt it to sum all the columns with the header "Normal"
I tried =SUMIFS($Z4:$JY300,$Z$3:$JY$3,"Normal",$Z$1:$JY$1,"="&$B$2) but get a value error
Thanks
Kevin
Bookmarks