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