Hi, hopefully someone can help me with the following query.
I want to return the sumif of coumn B on sheet 2 to column I4 on sheet 1, but only for statuses potential and quote sent.
Many thanks,
Hi, hopefully someone can help me with the following query.
I want to return the sumif of coumn B on sheet 2 to column I4 on sheet 1, but only for statuses potential and quote sent.
Many thanks,
I recommend using this formula... =SUMIFS('sheet 2'!B:B,'sheet 2'!$C:$C,'sheet 1'!B4,'sheet 2'!$A:$A,"potential")+SUMIFS('sheet 2'!B:B,'sheet 2'!$C:$C,'sheet 1'!B4,'sheet 2'!$A:$A,"quote sent")
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Try something like this:
The braces { } contain the values to be matched.![]()
Please Login or Register to view this content.
Adjust range references to suit your situation.
Is that something you can work with?
success, many thanks for your help!![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks