Skip to content
ProjectControls.com
Planning, Scheduling & Programming Discussion

Excel Formula

In the Open Standard
Oliver MellingMember for 19 years 5 months
Created
1
1
0

Can anyone tell me how to make the follwing formula sum "Apples" and "Pears"?

=SUMPRODUCT((Cost!$D$3:$D$126="Apples")*Cost!$P$3:$AG$126)

It would be much appreciated!

Save Follow Follow forum Report
Reply New topic

1 reply

Oldest first
  1. 0
    Ahmed KHR ·
    #1

    SUMPRODUCT((Cost!$D$3:$D$126=

    SUMPRODUCT((Cost!$D$3:$D$126="Apples")*Cost!$P$3:$AG$126)+SUMPRODUCT((Cost!$D$3:$D$126="Pears")*Cost!$P$3:$AG$126)

    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?