how to run a sumif after formula

[lneilson]

Hi all
how can i run this in the 1 cell of the last COLUMN with data +1

=sumif($a$12:$iv$12,"sun.",a1:iv1)



thanks


lneilson

[mdmackillop]

Can you clarify?

[lneilson]

I'll post some data so you can see

dont worry about the ref error that part works fine in my whole page

but I need that formula to run in Column I

thanks

[mdmackillop]

Insert in I1 and copy down
=SUMIF($A$12:G$12,"sun.",$A1:G1)

[lneilson]

I posted some data but put it in the wrong reply scroll up please

[mdmackillop]

I saw it.