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

Patriot2879

Well-known Member
Joined
Feb 1, 2018
Messages
1,036
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?

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

Some videos you may like

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

FormR

MrExcel MVP
Joined
Aug 18, 2011
Messages
6,343
Office Version
365
Platform
Windows
Hi, can't you simply multiply the result by 2?
 

Patriot2879

Well-known Member
Joined
Feb 1, 2018
Messages
1,036
how do I do that please? Can i still do this with countif?
 
Last edited:

FormR

MrExcel MVP
Joined
Aug 18, 2011
Messages
6,343
Office Version
365
Platform
Windows
Hi, simply:

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

Watch MrExcel Video

Forum statistics

Threads
1,090,472
Messages
5,414,733
Members
403,543
Latest member
Phx007

This Week's Hot Topics

Top