how to use COUNTIF formula to count a specific word twice instead of once?

[Patriot2879]

Hi I am using the countif formula below to count a specific work type and counting if a fixer has had the job but I want to count the word twice as it is duel fuel and should count as 2 jobs not 1 how can I do this please?

=COUNTIFS(Sheet2!A:A,"John Smith",Sheet2!Q:Q,"Install Duel Fuel")

 

[FormR]

Hi, can't you simply multiply the result by 2?

 

[Patriot2879]

how do I do that please? Can i still do this with countif?

 

[FormR]

Hi, simply:

=COUNTIFS(Sheet2!A:A,"John Smith",Sheet2!Q:Q,"Install Duel Fuel")*2

 

[Patriot2879]

no way that's great thank you