I
I
Igor Mamontov2015-03-04 14:55:51
Google
Igor Mamontov, 2015-03-04 14:55:51

How to write sum formula in google excel?

I am preparing a table with project data and the pivot table should count the number of days for given conditions from another sheet and the sum of days.
Given 4 excel sheets
3 projects + pivot table
In the project table there is a page complexity column with selection options, for example "complex" and "simple", in the pivot table you need to count the number of these pages and how many days they can be done ... is this possible?
Pivot
063584e2739e48a3851093152381d930.png
Table Project Table
bc961b1e5df947c3aae4b15a605625f1.png

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Anton Nagaets, 2015-03-04
@goonwarez

IMHO, simple formulas COUNTIF and COUNTIFS will help with your task

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question