formulas across multiple sheets

[Rhodestransit]

I need help in writing a formula for multiple columns
Here is the formula I have now
=SUMIF(AM!C$3:C$65536,'employee daily tally'!A2,'Run data'!B$2:B$192)
I need to add AM!F$3:F$65536,'employee daily tally'!A2,'Run data'!C$2:C$192)
and I will need to repeat this for another 10 or so columns.
I dont know how to enter this all into a single cell without getting the error messages.

 

[Airfix9]

I am assuming you wish to sum all the values in all ten columns, is that right?

=SUMIF(AM!C$3:C$65536,'employee daily tally'!A2,'Run data'!B$2:B$192)+SUMIF(AM!F$3:F$65536,'employee daily tally'!A2,'Run data'!C$2:C$192)+ etc

 

[Rhodestransit]

That was easier than I thought!
Thank you

 

[T. Valko]

I need help in writing a formula for multiple columns
Here is the formula I have now
=SUMIF(AM!C$3:C$65536,'employee daily tally'!A2,'Run data'!B$2:B$192)
I need to add AM!F$3:F$65536,'employee daily tally'!A2,'Run data'!C$2:C$192)
and I will need to repeat this for another 10 or so columns.
I dont know how to enter this all into a single cell without getting the error messages.

Airfix9 showed you how to do it but...

=SUMIF(AM!C$3:C$65536,'employee daily tally'!A2,'Run data'!B$2:B$192)

The sum_range is not the same size as the criteria_range BUT the formula will use a sum_range that IS the same size as the criteria range.

So, if effect, your formula is doing:

=SUMIF(AM!C$3:C$65536,'employee daily tally'!A2,'Run data'!B$2:B$65535)

 

[Rhodestransit]

Here is what im using
=SUMIF($AM.C$2:C$45;$'employee daily tally'.A2;$'Run data'.B$2:B$75)
+SUMIF($AM.F$2:F$45;$'employee daily tally'.A2;$'Run data'.C$2:C$75)
+SUMIF($AM.I$2:I$45;$'employee daily tally'.A2;$'Run data'.D$2:D$75)
+SUMIF($AM.M$2:M$45;$'employee daily tally'.A2;$'Run data'.E$2:E$75)
+SUMIF($AM.P$2:P$45;$'employee daily tally'.A2;$'Run data'.F$2:F$75)
+SUMIF($AM.S$2:S$45;$'employee daily tally'.A2;$'Run data'.B$78:B$98)
+SUMIF($AM.W$2:W$45;$'employee daily tally'.A2;$'Run data'.C$78:C$98)

it is only working for data in columns C, F, I none of the others return any of the values?
Is there a maximum number that it can check.