Formula Help

[James__S]

Hi

I use the following formula which works well

=SUMIF(CAR!$D$43:$D$907,$B4,INDEX(CAR!$H$43:$XFD$909,,MATCH(TODAY(),CAR!$H$42:$XFD$42)))

How do i add the following 2 formulas to the formula above so it sums the 3 tabs? I am hoping for a single formula

(BUS!$D$43:$D$907,$B4,INDEX(BUS!$H$43:$XFD$909,,MATCH(TODAY(),BUS!$H$42:$XFD$42)))
(BIKE!$D$43:$D$907,$B4,INDEX(BIKE!$H$43:$XFD$909,,MATCH(TODAY(),BIKE!$H$42:$XFD$42)))

Thank you

James

 

[Nine Zero]

perhaps maybe put those three as parameters for a SUM function like this maybe..

=SUM(car formula, bus formula, bike formula)

 

[James__S]

Thank you the formula works. Appreciated

Is there a simpler formula to achieve the same result?

Thanks