Завершен

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 день
(28 отзывов(-а))
4.3

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

(469 отзывов(-а))
7.7
P0L

(481 отзывов(-а))
8.0
(407 отзывов(-а))
7.6
(406 отзывов(-а))
7.6
(224 отзывов(-а))
7.0
(90 отзывов(-а))
6.5
(75 отзывов(-а))
6.0
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 день
(43 отзывов(-а))
5.4
(85 отзывов(-а))
4.8
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 день
(38 отзывов(-а))
4.6
(18 отзывов(-а))
4.3
(19 отзывов(-а))
3.9
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 дней(-я)
(15 отзывов(-а))
3.8
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 день
(11 отзывов(-а))
3.6
(3 отзывов(-а))
3.1
(1 отзыв)
3.2
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 отзывов(-а))
1.6
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 день
(2 отзывов(-а))
1.7
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 день
(1 отзыв)
0.4
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