Completed

Help Troubleshooting Complex Google Sheet Formula

I need to troubleshoot why this formula is returning the incorrect value. I can provide an example sheet once the job is awarded. The formula in question is:

=countifs('PM Capacity'!$A$2:$A$992,$A4,'PM Capacity'!$E$2:$E$992,B$3,indirect("'PM Capacity'!$"&B$1&"$2:$"&B$1&"$999"),"x")

Skills: Excel, Google Spreadsheets

About the Client:
( 1 review ) Princeton, United States

Project ID: #34833791

Awarded to:

(534 Reviews)
7.9

11 freelancers are bidding on average $24 for this job

ha4401310

I AM AVAILABLE RIGHT NOW ------------------------------------------------ Greetings! ----------------- I’m very much interested to your requirements and Job openings. I am a Professional in Google sheet with more years More

$10 USD in 1 day
(86 Reviews)
5.2
(49 Reviews)
4.9
monicawriter99

Hello employer, I hold a Master's degree in Economics and statistics making me a suitable person for your project " Help Troubleshooting Complex Google Sheet Formula ". I have more than 3 years of professional experien More

$40 USD in 2 days
(16 Reviews)
4.5
(10 Reviews)
3.7
solutionsplayers

Hi there, I am a Professional Data Entry Person & have More Than 7 Years Experience. My skills: 1: Microsoft word 2:Microsoft excel 3: Power Point 4: Pdf to word file Here is just a small overview of My Services how I More

$20 USD in 1 day
(11 Reviews)
3.3
Florencewriter1

Hi Am an experienced writer with diverse professional expertise, after a careful review of your project , I can confirm that I can handle your project. I have six years of experience in Excel and Google Spreadsheets, More

$15 USD in 1 day
(1 Review)
1.7
wilfrednjorog

Hello! I have vast experience in Excel and Google Spreadsheets, 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, More

$30 USD in 1 day
(0 Reviews)
0.0
luisrochem

( ͡° ͜ʖ ͡°) Hi Dawn! ¯\_( ͡° ͜ʖ ͡°)_/¯ I have rich experience in GSheet. I have to say, this job post really stuck out to me – I’m a perfect fit for this project. Go ahead and shoot me a quick message here so we can c More

$20 USD in 7 days
(0 Reviews)
0.0
jthenson50

I have programmed several Excel documents at my current full time job, and have had quite a few simple issues with Excel formulas. Should be able to figure this out pretty quickly.

$35 USD in 7 days
(0 Reviews)
0.0
Hatemcompt76

Bonjour, Je pense bien que je pourrais accomplir la tache convenablement vous pouvez compter sur moi Merci d’accepter mon offre Cordialement

$17 USD in 7 days
(0 Reviews)
0.0