Array formula question regarding summing data from two separate sheets

The following formula does exactly what I need to do for summing a data range on one worksheet that has a particular symbol, etc

Please Login or Register  to view this content.

but I need to have this same type of formula sum two data ranges in two separate sheets. I tried to amend this formula to this

Please Login or Register  to view this content.

, but it doesn't seem to work. Any suggestions would be greatly appreciated!

Can you post some sample data and tell us what result you expect?

If the ranges to sum were exactly the same on each sheet then you could probably come up with a single function to reference both sheets but since the ranges are not the same on each sheet then I can't see an easy way to do this.

You're going to have to do something like this:

=SUM(IFERROR(--SUBSTITUTE(UPPER(February!$C5:$J5),UPPER($A$2:$A$14),""),0))+SUM(IFERROR(--SUBSTITUTE(UPPER(January!$AB5:$AG5),UPPER($A$2:$A$14),""),0))

You're welcome. Thanks for the feedback!