#### tarynmahon

##### Member

I was wondering if there was a better way of doing this formula;

*Hint* (Its exactly the same formula 4 times)

=SUMIFS(APR14.DATA!$O:$O,APR14.DATA!$Z:$Z,$C11,APR14.DATA!$X:$X,'P&L CATS'!$A$1)+SUMIFS(APR14.DATA!$O:$O,APR14.DATA!$Z:$Z,$C11,APR14.DATA!$X:$X,'P&L CATS'!$A$2)+SUMIFS(APR14.DATA!$O:$O,APR14.DATA!$Z:$Z,$C11,APR14.DATA!$X:$X,'P&L CATS'!$A$3)+SUMIFS(APR14.DATA!$O:$O,APR14.DATA!$Z:$Z,$C11,APR14.DATA!$X:$X,'P&L CATS'!$A$4) Etc...

Basically the highlighted values depicts each line of a list of information, rather than adding the same formula over an over again like Im doing above and just changing this line I was wondering if theres a formula that could just lookup column A:A ?

Preferably without doing a SUMPRODUCT as this takes a lot of time with the size of the spreadsheet that Im using, also for this reason I dont think I should upload a sample.

Any help will be greatly appreciated