Multiple COUNTIFs and then Multiply by (Formula)

[Morey]

Following Formula works by returning a value total of 2. How do I add in multiply final count by $1445?

=COUNTIF('OCT 19'!I:I,"E")+COUNTIF('NOV 19'!I:I,"E")

I've tried this with no luck.

=COUNTIF('OCT 19'!I:I,"E")+COUNTIF('NOV 19'!I:I,"E")*1445

Regards,

Morey

 

[Fluff]

You need to put the sum portion in brackets like
=(COUNTIF('OCT 19'!I:I,"E")+COUNTIF('NOV 19'!I:I,"E"))*1445

otherwise it will multiply the 2nd countif by 1445 & then add the 1st countif

 

[Morey]

You need to put the sum portion in brackets like
=(COUNTIF('OCT 19'!I:I,"E")+COUNTIF('NOV 19'!I:I,"E"))*1445

otherwise it will multiply the 2nd countif by 1445 & then add the 1st countif

Fluff,

That did it. Thanks for the tips.

Morey

 

[Fluff]

You're welcome & thanks for the feedback