Link to home
Create AccountLog in
Avatar of nike_golf
nike_golfFlag for Afghanistan

asked on

Sumproduct question with a twist...

I need to Sum the "Actual" and "Budget" data from "Building" on distinct "Unit" supplying the Period" and "Building" for the formula.

Can anyone help?

NG,
screenshot.16.jpg
ASKER CERTIFIED SOLUTION
Avatar of Saurabh Singh Teotia
Saurabh Singh Teotia
Flag of India image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of nike_golf

ASKER

Do you have anything for a custom function that you could start me off with?

I don't have one right now, However if you are intrested can build one for you..if you can use it..let me know..so that can start building one for you...

Also is it possible for you to give the excel file as it will become easy for me to stimulate your data,...
I might try running with item 2 you suggested I'll post back... thanks.

NG,