Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Excel Sumif formula. I have the data on Tab Part C and I need to use Sumif to count each plant by QTy Used and
Excel "Sumif" formula. I have the data on Tab Part C and I need to use "Sumif" to count each plant by QTy Used and Sales into Tab Part D.
I confused how to use the SumIf critiria for excel to properly count each.
Thank You!
Tab Part C Data
Tab Part D: Count each by QTY Used and Sales. How do I use SumIf?
BUILD/ Quantity in PARK Stock BLD 12 BLD 48 BLD 31 BLD 3 BLD 40 BLD 17 Item # 1254-P 1578-P 2234-P 2238-P 2389-P 2452-P 3242-P 3243-P 3244-P 3245-P 3251-P 3425-P 3450-P BLD 8 2 35 62 70 42 BLD BLD BLD BLD BLD BLD BLD BLD BLD BLD 42 67 3451-P 3 45 Price Plant Size Qty Used Sales 34.99 Tulips 10 inch 75 $ 2,624 49.99 Roses 14 inch 82 $ 4,099 36.95 Hastas 10 inch 102 $ 3,769 14.99 Lilac 10 inch 35 $ 525 15.95 Dieffenbachia 20 inch 115 $ 1,834 44.95 Spirea 10 inch 87 $ 3,911 29.99 Dieffenbachia 20 inch 98 $ 2,939 35.95 Crocus 14 inch 125 $ 4,494 45.99 Crocus 10 inch 88 $ 4,047 45.95 Dieffenbachia 14 inch 123 $ 5,652 49.94 Tulips 14 inch 46 $ 2,297 35.95 Crocus 20 inch 79 $ 2,840 45.95 Marigolds 14 inch 82 $ 3,768 34.95 Crocus 10 inch 69 $ 2,412 34.99 Dieffenbachia 14 inch 107 $ 3,744 17.95 Crocus 20 inch 128 $ 2,298 14.99 Spirea 14 inch 128 $ 1,919 34.99 Hastas 20 inch 138 $ 4,829 34.95 Daisies 10 inch 53 $ 1,852 34.99 Spirea 10 inch 49 $ 1,715 35.99 Daisies 10 inch 128 $ 4,607 14.95 Spirea 10 inch 54 $ 807 34.99 Geranium 20 inch 87 $ 3,044 34.99 Spirea 14 inch 88 $ 3,079 17.96 Dahlia 14 inch 119 $ 2,137 42.95 Spirea 20 inch 82 $ 3,522 17.99 Dieffenbachia 20 inch 121 $ 2,177 17.99 Dahlia 20 inch 78 $ 1,403 35.95 Lilac 14 inch 45 $ 1,618 49.99 Petunias 14 inch 101 $ 5,049 39.99 Marigolds 20 inch 99 $ 3,959 39.95 Spirea 10 inch 89 $ 3,556 17.95 Dahlia 14 inch 87 $ 1,562 44.99 Marigolds 14 inch 131 $ 5,894 6 30 BLD 45 24 7 BLD BLD BLD BLD BLD BLD 4 8 3452-P 3453-P 3455-P 3456-P 3458-P 3478-P 3522-P 3543-P 3566-P 3567-P 3578-P 3677-P 4233-P 4235-P 4238-P 4251-P 4255-P 4355-P 4532-P 4562-P 32 50 14 BLD BLD BLD BLD 7 70 42 BLD 51 7 BLD BLD BLD BLD BLD 65 42 7 PARTB PARTD PARTC PARTA DATA1 PARTE PARTE DATA2 DATA3 Plant Qty Used Sales Tulips Roses Hastas Lilac Dieffenbachia Spirea Crocus Marigolds Daisies Geranium Dahlia Petunias Primrose
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started