Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

Tab Part D: Count each by QTY Used and Sales. How do I use SumIf?

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Frank Woods Business Accounting Volume 2

Authors: Frank Wood, Alan Sangster

11th Edition

0273712136, 9780273712138

More Books

Students also viewed these Accounting questions