Завершен

Excel COUNTIFS on different sheet

See file. I need syntax help please

=COUNTIF('>Prep3'!B2:C2,">0")+

COUNTIFS('>Prep3'!N2:O2,">0",'>Prep3'!B2:O2,'>Prep3'!N2:O2='>Prep3'!B2:C2)+

COUNTIFS('>Prep3'!Z2:AA2,">0",'>Prep3'!B2:AA2,'>Prep3'!Z2:AA2='>Prep3'!N2:O2)

Навыки: Excel

О клиенте:
( 36 отзыв(-а, -ов) ) Newark, United States

ID проекта: #33988350

Поручен:

MamukaB

Hi I can help to you. It's easy job for me. Can do within few hours I have 15+ year experience of Excel, Excel VBA So, you can trust to me. Result will be excellent Best Regard

$15 USD за 1 день
(41 отзывов(-а))
4.7

28 фрилансеров(-а) готовы выполнить эту работу в среднем за $20

(566 отзывов(-а))
8.0
P0L

(483 отзывов(-а))
8.0
(429 отзывов(-а))
7.7
(412 отзывов(-а))
7.6
(225 отзывов(-а))
7.0
(114 отзывов(-а))
6.4
(97 отзывов(-а))
6.6
(51 отзывов(-а))
6.1
IgeS

Hi there, Need the syntax for the count if and ifs functions, please message me. I'll be standing by to help. -Ige

$12 USD за 1 день
(44 отзывов(-а))
5.4
(104 отзывов(-а))
5.2
(35 отзывов(-а))
5.0
AAGGMM

Hello sir I am Ahmed, a GOOGLE certified data analytic with very good skills in spreadsheets [(Google sheets and Excel); including advanced formula, macros, power query and pivot tables], SQL and R-Programming languag Больше

$20 USD за 1 день
(58 отзывов(-а))
5.1
edatawiz

Hi there - I looked at your excel file. If the cells are merged, in your case B2 and C2, calling B2 alone should do the trick. Also, I am trying to understand the purpose of using countif/s here. If the cell you wan Больше

$20 USD за 7 дней(-я)
(18 отзывов(-а))
4.0
Maherun75

"Dear Client, I specialize in Word or Excel VBA / Macro solutions and Web Scraping/Data Mining for your Excel workbooks. I will perform any tasks in Excel to automate your business. VBA macros, custom forms, charts, ta Больше

$20 USD за 1 день
(14 отзывов(-а))
3.9
alamineee

Hi, Dear Employer, I am Al.A. I am a Ph.D. backgrounder and professional Excel Expert. I will provide you high-quality Excel file. I have worked on several similar projects of excel and can deliver professional excel t Больше

$20 USD за 1 день
(4 отзывов(-а))
3.4
(2 отзывов(-а))
3.3
(3 отзывов(-а))
3.1
Ibrahim8896

Dear Sir! I have read the description, let me handle this project because I am Proficient in these type of Projects. I have completed a lot of similar type of projects in the past and got good ratings and appreciation Больше

$20 USD за 1 день
(2 отзывов(-а))
2.2
akibul18

Hello Dear, Hope you are doing well. I am a Excel VBA expert and have been on it for more than 5 years. Currently I am working at a real estate company where my responsibility is to control the flow of data and automa Больше

$25 USD за 1 день
(3 отзывов(-а))
2.2
wilfrednjorog

Hi there! I have vast experience in Excel, and I am confident that I can produce quality content for you that will be of interest to your readers. I am available for a full-time writing position, and I am happy to wor Больше

$30 USD за 1 день
(0 отзывов(-а))
0.0