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

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

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,427
Messages
5,414,414
Members
403,526
Latest member
swedeness50

This Week's Hot Topics

Top