Hi all,
I'm looking to create a sumifs formula that i can drag across that effectively skips 3 columns.
I've tried using the offset column function but it seems i haven't got it quite right.
Can anyone please assist?
Cheers
Hi all,
I'm looking to create a sumifs formula that i can drag across that effectively skips 3 columns.
I've tried using the offset column function but it seems i haven't got it quite right.
Can anyone please assist?
Cheers
In C2, copied across and down:
=SUMPRODUCT((Detail!$A$2:$A$13=Summary!$B2)*(Detail!$B$2:$B$13=Summary!$A2)*(Detail!$C$1:$L$1=Summary!C$1)*Detail!$C$2:$L$13)
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Hi, look like you are trying to sum per quarter starts from monh 1,4,7?
Try in C2:
SUMIF(S), COUNTIF(S) does not work with range that born from formula ( range from OFFSET...)Please Login or Register to view this content.
Quang PT
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks